Combo Box retaining value on form

[David1234]

Hi All,

I'm currently working on making a database that deals with my companies returns department, but have hit a stumbling block early on!!

I've got a bit of experience in Access, but haven't uesd the programme in a few years so bare with me!

I have created my main form based on a table, which is linked correctly.

Two of the items on the main form are Combo boxes being run from Queries, these are my customer name, and product information. These work fine on a single form..but as the form will be used for entry of any new enquiries it doesn't work.

The issue can be explained as follows....

Return No.1 is for customer ABC for product DEF, the information is filled in on the form and completed.

Return No.2 is for customer GHI for product JKL...but the information in the Combo boxes is still remaining from Return No.1, and if these are deleted then the information is deleted from No.1 and No.2

It has to be combo specific as the remaining information from list boxes, text boxes etc is retained on the original record!

 

[YNWA]

Post your DB for a closer look.

When you add a new record, do all the other fields go blank, except for the 2 drop down menus?

 

[David1234]

That's correct, the other fields on the form remain on their single record - The combo boxes feature as a static in every record - But they are always the same

 

[YNWA]

Sounds like you dont have them dumping their info somewhere. Are the selections in the combos being store in the table or is the table fields for these blank?

What is in the control source of each combo box?

 

[David1234]

The control source for both is blank.

Is it because of that?

 

[YNWA]

The control source for both is blank.

Is it because of that?

Yes, your combox boxes are what is called unbound, ie. not attached to anything.

There should be a drop down in the control source, with a list of fields to store your combo selection in. Select the correct fields for each.

The fields in your control source come from the forms record source, so make sure your forms record source is pulling the correct fields/table/query through.

In the properties of each combo, ideally you should bound column: 1, then set the column widths to 0; 2cm if you have 2 fields in your reference table (this being the table with your combo list in).

Post your DB and I can tell you if its set up ok.

In your table in which you are storing you combo box data, are you storing the text or the ID?

 

[David1234]

No need to upload the DB as the suggestions you've made have got it working perfectly! Thanks!