Keeping the same record when moving between forms

[andrewhoddie]

Hi all

Hopefully this is a fairly simple one.

I have a form called DataEntry which has a field called ID which is an autonumber field which produces a reference number. Once the details are added there is are two buttons that can be pressed depending on the user. If command button 1 is pressed it takes you to form Initial Assessment and if Command button 2 is pressed it takes you to form ASB Initial Assessment.

When it redirects to the Initial Assessment form it does not keep the reference from the DataEntry form but starts at the first reference field. I would like it to keep the same record from as shown on the DataEntry form.

Example On DataEntry I add a new record with an ID of 30 and I press the Command Button 1 and the Form Initial Assessment opens but on record 1 not record 30.

Hopefully this makes sense, if not please do not hesitate to ask.

Thanks in advance for your assistance
Andrew

 

[ranman256]

open the form with the ID in tow....

sub Command button 1 _click()
 docmd.openform "Initial Assessment",,,"[id]=" & me.id
end sub

sub Command button 2 _click()
 docmd.openform "ASB Initial Assessment",,,"[id]=" & me.id
end sub

 

[andrewhoddie]

Works a treat, thanks very much for your help