Double Click current record to Edit

[projectpupil7]

Hi June7, i was just wondering if you have managed to do anything more to my file. I am asking due to my coding skills being at beginners level. Or were you only making suggestions for me to do. Apologies if i have misunderstood but just asking in case.

[June7]

I made suggestions for correcting the described issue. Does not involve code. Just fix the form RecordSource as described.

[projectpupil7]

OK June7, made the changes as you suggested. The bit i am stuck on is this because i don't know how to code it.

"Nothing in this arrangement will save the ClientID into the new record. Will require more code. This query also has a dynamic parameter that references frmReactiveTracker for filter criteria. I NEVER use dynamic parameter queries".

A new record is visible in the table but of course is no good if the ClientID is not there also.

I hope you can help!!.

[June7]

One way is to pass the ClientID with OpenArgs. Example:

DoCmd.OpenForm "formname", , , , , , Me.ClientID

Then pull the value from OpenArgs with code in the called form OnCurrent event.

If IsNull(Me!ClientID) Then Me!Client = Me.OpenArgs

Programmatically setting value initiates record. Now if you want to allow user to cancel this initiated record, that's another can of worms.