Add command not working after reopening the form

[kpalar]

Dear All,

I have created a unbound form with command button to add record using VBA code. It works as long as I do not close the Database. Once close it and reopen it doesn't work. Please advise.

[pbaldy]

Might help to see the code.

[Missinglinq]

Aside from the inadvisability of using Unbound Forms for data entry, in Access, when code runs after written, but doesn’t run after Access is closed then re-opened, in 2007 or later, the folder Access file resides in needs to be declared as 'Trusted.'

To "Trust" your folder, click:

• Office Button (top left)
• Access Options (bottom of dialog)
• Trust Center (left)
• Trust Center Settings (button)
• Trusted Locations (left)
• Add new location (button)

Linq ;0)>

[kpalar]

Aside from the inadvisability of using Unbound Forms for data entry, in Access, when code runs after written, but doesn’t run after Access is closed then re-opened, in 2007 or later, the folder Access file resides in needs to be declared as 'Trusted.'

To "Trust" your folder, click:

• Office Button (top left)
• Access Options (bottom of dialog)
• Trust Center (left)
• Trust Center Settings (button)
• Trusted Locations (left)
• Add new location (button)

Linq ;0)>

Thank you very much. I works now

[Missinglinq]

Glad we could help!

Linq ;0)>