Adding a new Record using a Form

[Malikei29]

I have designed my table, Query, and Form. Everything works well. I can see my records in my form and all the data is correct.



My problem is now that I want to add a new record using a form.

However, I can only view records that I have entered in my table/query.

I want to create a Main menu (which I know how to do) and then add a "ADD NEW RECORD" button.

I have created the button but when I click on it nothing happens.

Please Help I'm lost.

[JoeM]

However, I can only view records that I have entered in my table/query.

It sounds like either:
- You are basing the Form on an Unupdateable Query, so you cannot add or edit records through it. If this is the case, create a new Form based either directly on the Table or on an Updateable Query.
- You have the "Allow Additions" property on your Form set to "No". If this is the case, then just change property.

Note, if you want a form for new data entry only, change the a "Data Entry" property to "True".

[Malikei29]

Thanks, JoeM. I have changed all the properties as mentioned, and I have recreated my form directly from the query. However once I have added my "ADD NEW RECORD" button and click on it it still does nothing. I have been told I need to use V.B.A. But I don't know how. Can anyone please assist.

[JoeM]

How exactly did you add the "ADD NEW RECORD" button?
If you go to the Properties on that button and go to the Event tab of the Properties, are any of the Event fields populated?
If so, which ones, and what are they populated with (if VBA code, please provide the code)?

[Missinglinq]

...I have recreated my form directly from the query. However once I have added my "ADD NEW RECORD" button and click on it it still does nothing...

As JoeM said, it sounds as if your Query is Read-Only, as most multi-table Queries are. Can you open the Query directly and add a Record?

Linq ;0)>