Form/Subform problem

S

snelson1

I have a form (Applicant) that has a combobox used to select a
applicant and then show the appropriate data. No problems with this

I have a form (Business) that has a combobox used to select a Busines
and then show the appropriate data. No problems with this

The Applicant form has a subform that shows any connected businesses
(can be multiple)

The Business form has a subform that shows the connected applicant.
(will only be one)

Both subforms seems to work well.

On the subforms I have a button that takes me to either the Applican
form or the Business form at the appropriate record, this is where
have a problem, after using the buttons I cannot then use the dropdow
boxes to search for records.



Hopefully this will be something you have come across before and wil
be able to assist me.



Thanking you in advance
 
A

Allen Browne

Presumably your button loads the other form with just that one record, e.g.:
DoCmd.OpenForm "Business", WhereCondition:="BusinessID = " &
Me.BusinessID

Then when you try to find another record in the Business form, it cannot be
found because there is only one record loaded.

If that is the case, you could change the code in the combo's AfterUpdate
event so that it turns the form's FilterOn property off before it tries to
find the record. This kind of thing:
Private Sub cboFind_AfterUpdate()
If Me.FilterOn Then Me.FilterOn = False
'the rest of your code in here.
End Sub
 
S

snelson1

No doubt about it, you are good. Did what you suggested and the thin
works like a charm.

Thank you and I look forward to trying stump you in the future
 
Top