comboboxes on a form

[ageurtse]

Hello,

i'm pretty new with Access and i'm running into a small problem.

I use Acces 2016

in my database i have several tables:

tblObjects
---tblContacts <- this is linked to tblObjects, one object has many contacts

tblRvOP with the folowing fields
ID
Objectid
Contactid

now here is my problem.



i have made a form with 2 comboboxes one filled with the objects out of the objects table.
and the next one is filled with the contacts out of tblContacts filtered bij objects

this is working working, but when i save the record en insert a new record the data is correct stored in the table.
But when switching from one prefilled record to another prefilled record the data is not displayed correct.
How do i display the correct information in the comboboxes. the problem is only in the combobox cbcontacts the cbObject is displayed correct.

i hope you guys have enove information.

[alansidman]

On this link are some Access tutorials. Scroll down to the ones on Combo Boxes. This site was developed with earlier versions of Access, but the concepts still remain valid today.

http://www.datapigtechnologies.com/AccessMain.htm

[ageurtse]

i already find this tutorials, but this is not on a table based form.
Or how do i say it.

My form is a record where the selected item's from the combo's are stored in.

[alansidman]

I am not understanding your last post. Perhaps you should upload a sample db and explain using that db as an example of what you want to happen.

[ageurtse]

that i wil try.

[aytee111]

Is the table storing the correct value from the combobox? This is the column defined as the Bound Column in the combobox's properties.

[ageurtse]

and here is my project file the correct form is frmRapportvanOplevering

http://www.steinor.nl/Gebruikers_Basis11.accdb

[aytee111]

I saw a thread about this once but can't seem to find it. You have to have two comboboxes, one on top of the other, and make them visible/invisible as the case may be.

Combobox 1 with criteria, combobo2 without criteria.
- on open, c-1 is invisible
- in after update of main combobox, set c-1 visible, c-2 invisible
- in after update of form, set c-1 invisible, c-2 is visible

[ageurtse]

now they both should be visible.
And when going cycleing trhough te records, it should display the correct information.
and i need to alter those inputs .

[aytee111]

Don't understand what you are asking. If it still isn't working after making the changes, repost your database.