combo box for a filter or search

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

Guest

I have a form with a sub form, the main form has one field Job No the sub
form is were I would like to enter data for that job no. I have a table
called job no and the job no field on the form is a combo box that look ups
data form the job no table I do not want to update or inter data into the job
no table from this form. I would like the combo box to work like a filter or
search so win I pick a job no from the combo box it would go to that record.
thanks
 
hucktx said:
I have a form with a sub form, the main form has one field Job No the
sub form is were I would like to enter data for that job no. I have a
table called job no and the job no field on the form is a combo box
that look ups data form the job no table I do not want to update or
inter data into the job no table from this form. I would like the
combo box to work like a filter or search so win I pick a job no from
the combo box it would go to that record. thanks
Click to expand...

Then neither the ComboBox nor the main form need to be bound. Remove the
ControlSource from the ComboBox and the RecordSource from the main form. The
MasterLink and ChildLink properties will still cause the subform to display data
matching the entry in the ComboBox.
 
ok i removed the controlsource and the recordsource but this lets the subform
show all record
is there a goto that would read the combo box and then goto that record and
not update the job no table?
 
Back
Top