Really Tricky Problem (1 Viewer)

[Haynesey]

Hi,

When opening a main record form from another form, the main record form shows the person details from the other form. Normally, if you were to go straight into the main form and selct a person, after update, all related combo boxes on the form would update. However, when going into the main records form from another form, meaning the persons details are already entered, when attempting to select from the other combo boxes on the form to add details, nothing is shown. I have tried refreshing the form on open and current but that doesn't work.

Please help.

Frustrated...

 

[Freddy]

You problem is a bit hard to follow. Can you describe you problem in more detail?

Have you tried a requery on the combo box?

 

[Haynesey]

Hi,

Thanks, how do I do that???

Cheers
Lee

 

[Vassago]

Try posting a sample of your database and using the actual names of the fields and forms that you are having trouble with. Your description is a little hard to follow.

 

[Pat Hartman]

It seems that the code you are using to populate the details fields is triggered by an update event. You could also run the code from the current event as long as you are not on a new record. Or, you could change your form's query to join to the details table. That way, Access will populate the details fields for you. You won't need any code.