can i have a form open to a certain record

[reservedbcreater]

for example the first form asks the user to enter an ID . (ID is an
autonumber which happens to be equal to record #). then the user clicks
go button and i want it to open the general information form at that
certain record.

 

[fredg]

for example the first form asks the user to enter an ID . (ID is an
autonumber which happens to be equal to record #). then the user clicks
go button and i want it to open the general information form at that
certain record.

Code the command button click event:
DoCmd.OpenForm "OtherForm", , , "[RecordID] = " & [ID]

 

[reservedbcreater]

thanks i am picking up access developers hand book so hopefully i wont post
such simple questions much longer

 

[Penguin]

Glad to hear you got the book. You will get great tips and hints.