Using Multiple Combo Boxes in Search For Record Macro

cnodadmo

Registered User.
Local time
Today, 04:07
Joined
Aug 11, 2012
Messages
12
This is the first time I've had to deal with retrieving a record using two combo boxes. I got this to work in the first form where it's only one combo box using an embedded macro After Update and in that macro I have a "SearchForRecord" with a Where Condition that equals the record I want to retrieve in the form so I can make updates to. When I try to mimic this with two combo boxes to return the record I want to search for the form doesn't display any records. Can anybody help me out? I've attached a copy of the database I'm working with. I'm trying to get the frm_Edit Accounts to work using the Master_ID and Facility_Number combo box values.
 

Attachments

Users who are viewing this thread

Back
Top Bottom