Can't get form to add a new record

[arthuro111]

My problem is probably very simple, but here goes:

I made a form based on an underlying relational database.

I put a sample entry in the database, which displays on the form.

The problem is I can't add new entries. Whenever I try to I get a prompt that says "You can't go to the specified record"

For now everything is directly linked to the tables. I had the same problem with a query though.

It is set to allow updates.

Help!

 

[JunglesMcBeef]

So you have set the form properties:

Allow Additions = Yes
Recordset Type = Dynaset

?

It sounds like a property setting needs to be changed. If it isn't one of these 2, double check the rest of your database and form properties.

 

[arthuro111]

Yes, all those things are set the way they are supposed to be.

I notice that if I only reference one table in the form, then I can add new entries.

But when I reference more than one, I can't.

So do I need to make a top layer table that gathers everything on the form, then make a query that distributes this data to the relational database underneath?

Obvious questions I'm sure but I'm stuck!

 

[JoeCruse]

It sounds like you are using one form to enter data into 2, or more, tables. If so, you might consider using one form for each table. You could then make one form your main form, and add the 2nd form as a subform on your main form, linking them by Master/child relation in the forms properties.

Joe

 

[arthuro111]

Thanks everyone for your help, I got it figured out by using subforms. Mostly a consequence of not having done much work in Access.