Form refresh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which is set to display no records on load until a name is
selected from a combo box.

I have now built in a wildcard parameter query to help the user find the
correct name for a record based on any fragment of any name. This process
opens up a second form which is based on the query results. I then can
double-click on the name I am interested in and this opens up a copy of the
first form but with the selected named record automatically opened up.

How can I avoid having to use a second form ie be able to pass back the
query results to the original form and refresh it?

Thanks in advanace

Peter
 
Create a Form with two objects
1. The combo with names as you have now
2. SubForm that is based on the query, that I assume have reference to the
combo name in the main form

Select * From TableName Where FieldName= Forms![FormName]![ComboName]

3. On the after update event of the combo refresh the data in the sub frm

Me.[SubFormName].Requery
 
Back
Top