Run Form thru Query back to Form

  • Thread starter Thread starter Deema
  • Start date Start date
D

Deema

Part 1: I currently have a form (Form A) that asks the user to select (from
a combo box) a Technician Name and then manually enter a date (via an input
mask of 00/00/00). The user then selects the OK (command button) for the
results which show in a query (Query 1).

Part 2: Instead of the results showing in a query(Query 1) I would like the
results to show in a form (Form 2) that would allow the user to edit data,
etc.

I have Part 1 completed and have a form (Form 2) already built for Part 2
but do not know how to link the query (Query 1) results to my form (Form 2).

Sorry if confusing and not sure what additional info you may need. Any help
is greatly appreciate.

Thanks, Deema
 
Deema,

You can open a form to display one record by using the WHERE option of the
DoCmd.OpenForm command. I'm assuming that you have a table with the records
for technicians and call dates.

DoCmd.OpenForm "frmForm2", acNormal, , "Tech = " & Me!cboTech & " AND
CallDate = #" & Me!txtCallDate & "#"

A better option might be to have just one form, bound to your data table.
Put your combo box and date box in the form header. When the user changes
either, you can use the Filter and FilterOn properties of your form to go to
the correct record.
 
Scott:

Thank you for the suggestion of using just my form and the apply filter
option. Much easier.

Thanks a million . . . huge time saver!!!!
 
Back
Top