Sorry, I think I realized the problem. The record source query that I was using was based on a table that didn't have a primary key defined. Once I defined the main table ID field as the primary key, it came together.
Hi all,
Have a question I can't get around. I've done this before and for some reason can't get it to work this time.
I'm opening a form through docmd.openform, and trying to get it to open an blank form to allow me to add a new record. Problem is, every time I run the method, it opens up the first record in the database, rather than give me a new emtpy record. Please help!!!!
I'm using:
DoCmd.OpenForm "frmComm", acNormal, , , acFormAdd
I always thought that "acFormAdd" would provide me with a new empty record, but it's not working. Could the problem be with the form that is being opened? I inactivated all code for the new form, so there are no methods working there, still doesn't work.
What am I doing wrong?
Robin
