Novice
Windows 7 32bit 
Access 2010 32bit
create a button to open a form for data entry
i have this event procedure "DoCmd.OpenForm "FormName", , , "[PKID]=" & Me![PKID]" it opens a form base on the [PKID]to view the details, but my problem is when i click to an empty record (doesnt have PKID yet) to enter a new record it returns an error message.... any idea please......
and thanks....
Access Developer
Windows XP Access 2003
Try:
DoCmd.OpenForm "FormName", , , "[PKID]=" & Me![PKID], , , Me![PKID]
Then in the forms Before Update event:
Me![PKID] = Me.OpenArgs
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Novice
Windows 7 32bit Access 2010 32bit
thanks a lot Bob....
i had another question, can you recommend any book or video tutorial on how to create macros or vba for access???
goodluck and Godbless
Access Developer
Windows XP Access 2003
Glad you got it working.Originally Posted by dave john
As I use A2003 I don't feel I could recommend any books on A2010.
I'm sure that if you google "ms access tutorial" you will find plenty to get you going.
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Open report from data entry form
Posting Permissions
Reply With Quote