Find an specific record based

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

Guest

I have a table where I have :

IDDataBase Part ID WOID Cut_Process Cut_Process_Date
==============================================
AutoNumber Text Number Yes/No Date/Time

these field are updated at the begin of the process
IDDataBase Part ID WOID
but then at the middle of the process we need to update Cut_Process &
Cut_Process_Date , I have created a Form to update these field, but I don't
know how to go to the specific record just Typing a WOID number previously
updated

please help with any ideas to make this works
 
Are your WOID numbers unique?
If so, you could create a combo box on your form using the wizard.
Select the appropriate fields and options as you go through the wizard and
it will set it all up for you. Then, by select a particular WOID in the combo
box, your form will go directly to that record.

If they are not unique, you could click in the field and then Ctrl+F or
click the 'Binoculars' icon in your menu bar and search for a particular
WOID. If there are more than one, you can just click the 'Find Next' button.

Steve
 
DoCmd.OpenForm "YourFormName" , , , "WOID =" & Me.WOID

put that into an [Event Procedure] on a command button and you will open the
form to the record(s) for that WOID.

If you use a combo box's after update event it might look like:

Me.RecordsetClone.FindFirst "WOID = " & Me.ComboBoxName
Me.Bookmark = Me.RecordsetClone.Bookmark

or use the combobox wizard
 
Hello Arvin, thank you so much for your help, it works perfectly

Thanks again


--
Lorenzo Díaz
Cad Technician


Arvin Meyer said:
DoCmd.OpenForm "YourFormName" , , , "WOID =" & Me.WOID

put that into an [Event Procedure] on a command button and you will open the
form to the record(s) for that WOID.

If you use a combo box's after update event it might look like:

Me.RecordsetClone.FindFirst "WOID = " & Me.ComboBoxName
Me.Bookmark = Me.RecordsetClone.Bookmark

or use the combobox wizard
Click to expand...
 
Back
Top