Search data in forms

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

Guest

I have a database with tables that store job names under a number, purchase
order numbers and vendors that the purchase orders are for. I need to be
able to search the job name form for specifice data, such as name, date,
designer (some of the fields in the table). I would also like to set up the
form to open to the last record entered, it makes it easier when assigning
job numbers.
 
If the form is bound, as I assume it is, you can search for data in any
field by putting your cursor in the field and clicking Ctrl-F.

To have the form move to the last record when opening it, create a
small routine in the form's OnLoad event. Something like:

Private Sub Form_Load()
DoCmd.RunCommand acCmdRecordsGoToLast
End Sub

HTH,
Barry
 
Back
Top