Open the form newly created record after data entry?

[cw3k]

Hi, I am new to Access. I want to know if the follow Access can set to open the form for the newly created record after data entry is completed.

The form is a new client details form. I want Access to open the newly created record after data entry is completed. The data entry new client form and the Client Detail form (which has more fields) for view is 2 different forms.

Thanks.

 

[King Kreglo]

Run this macro on one of the records in the New Client Form, lets say [Client Name].
New Client Form : txtClientName : After Update
SetTempVar (CurrentClientID,[Screen].[ActiveControl])
OnErron (Next,)
Requery ()
Refresh

Finally set the default value for [Client Name] (in the Client Detail Form) as the following:
=[TempVars]![CurrentClientID]

I only have about 3 weeks of Access experience myself, so it's not as difficult as it may sound to do but I guarantee you it will do the trick

 

[cw3k]

Can you post a screenshot?

Sorry, I am a total noob.