Using VBA with Forms that have subforms

M

m cotton

I am having difficulties with getting my visual basic code to execute commands. For instance, I have an "Allow Edits", "No Edit", "Next Record", "Print this Record Only" commands with some underlying visual basic message code.

The visual basic code worked perfectly until I created two subforms on the Main Forms. The form is working perfectly with the subforms, but the problem as stated before is getting my commands working correctly. See below

Private Sub Command70_Click (

If Me.AllowEdits = True The
Me.AllowEdits = Fals
End I

End Su

The above is the command button Allowing Edits. Since I have added the subforms this command no longer works. Plus I am having problems with the main form printing out the "current record", it is trying to print out every record in the database

Puzzled..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top