open form to same record

[Schmidtty]

I am hoping some one has a solution to this one............

I have a form with a tab control in it. From this tab control I have a button that opens a seperate form for more detailed information. All my data is in one table, however when I launch the seceond form I am back at record number 1. I want the form to open to the same record I was looking at in the previous form?

 

[mission2java_78]

I am hoping some one has a solution to this one............

I have a form with a tab control in it. From this tab control I have a button that opens a seperate form for more detailed information. All my data is in one table, however when I launch the seceond form I am back at record number 1. I want the form to open to the same record I was looking at in the previous form?

Hi Sch,

The DoCmd.OpenForm method has arguments.
Look at those arguments. One of the arguments is Im quite sure a WHERE clause. So you could so something like this:

DoCmd.OpenForm blah, blah, "[RecordID]= " & Forms!yourFrm!YourField.Value

 

[Schmidtty]

That code then gives me a prompt for the field.
I just want it to read the record in form one and open to form 2 ?!?!?!?!?

 

[mission2java_78]

That code then gives me a prompt for the field.
I just want it to read the record in form one and open to form 2 ?!?!?!?!?

Check the name of ur fields.

 

[TurboDieselOne]

try the Button wizard to Open form with related info from you present form and record.