Access: drop down menus in forms

Question

I'm trying to create drop down menus for some of my options... the problem is that I can get the drop down menu, however when I then go to my next form it automatically inputs the drop down menu data from the first form... can someone advise me on how to stop the drop down menu inputting all the same data into all my forms? Thanks

Answer 1

You really need to define this in more detail. A combobox (sometimes referred to as a drop down) a control that can interface with data. If the ControlSource of the combo is set to a field in the form's Recordsource, then any change in the value of the combo will be reflected in the table. So if you open a new form to the same record, that data will be shown.

Answer 2

Design the form. Right-click the combobox. Select Properties. In the Properties window find the ControlSource property and wipe out any value that was there.

Answer 3

just delete it from the Properties dialog

Answer 4

Yeah I mean combobox sorry, please can you tell me how to remove the ControlSource property?

Answer 5

With drop down menu, do you mean combobox? Maybe you need to remove the ControlSource property? Hard to know without more specifics.