linking forms but being able to navigate to all records

[arobbo]

hi all

basically i want to have a button that opens up a form that links to the record i'm currently viewing. But then i want to be able to navigate to the other records, in access when you use the wizard to find specific data on a form it doens't then let you navigate to the other records

anyone got any ideas

cheers

Andy

 

[arobbo]

sounds like that could do the trick , would i do that on the button that opens the form or on the new form that is opened ?

 

[ailyn]

Sorry for my prev. post I erased it because it was wrong. I'm a newbie too ^.^'
Why don't you try this instead:

DoCmd.OpenForm stDocName
Forms!FormName!FormControlId.Value = Me.ctrlId

Otherwise I guess it will be something like DoCmd.FindRecord. search for info there (and that code was for the button that opens the form).

 

[arobbo]

i'm getting an error message

can't assign a value to this object ....

any ideas