Question Imported data handling

[HawLisa]

I have created a new client contact database and imported the client details from the old one. The table has come across fine, but the form that relates to the table will only display the first record and will not allow any additional records to be added. Where have I gone wrong??? :banghead:

 

[Roku]

Not a lot to go on here!
Have a look at the Form properties under the Data tab. Check that 'Allow Additions' is set to 'Yes'.
Whilst you're in that tab, check the Record Source is as you expect (either pointing to the table directly, or invoking a query which references the table).
If that doesn't work, please provide greater detail.

 

[HawLisa]

Thanks Roku,
I checked the properties and it does allow edits. Under Record Source it has SELECT Contacts. If I use the dropdown menu and choose Contacts (which is the table that I imported the data to) it then shows all of the records in the form. The only problem is that I have the form accessing a number of different related tables and choosing Contacts defaults all fields in the form to the Contacts table. I'm not sure if this is enough info to go on, I have come back to using Access after a number of years not needing it, so am a bit rusty on the techy side of using it!

 

[HawLisa]

Under Record Source it has SELECT Contacts.

I have rechecked this and it actually has SELECT and then all the tables, so it is a query. If I redirect it to just one table, the data appears, but the rest of the form doesn't work. How can I import the data but still have the form work?

 

[Roku]

In your original post, you said:

The table has come across fine, but the form that relates to the table will only display the first record and will not allow any additional records to be added.

In your latest post you said:

If I redirect it to just one table, the data appears, but the rest of the form doesn't work.

My question is: What do you mean by 'the first record'? I assume you mean the query which links the tables, which would be a collection of physical records.
Would you post more details of the tables involved and the full syntax of the query, please?
Which version of Access are you using for the new DB? Is it the same version as the original DB?

 

[HawLisa]

I seem to have sorted it out. I had one form with a number of tabs and the form related to a number of tables. The original database had a collection of forms for each table. I only wanted to import one table. Where I still had the form related to a number of tables, the form would only display one record (the first record from the table) and not allow any others. Once I changed it to only relate to the one table all records are displayed and editing is allowed. I have got around the other problem by merging two of the tables and using subforms for displaying data from the other related tables.

Thanks for the suggestions, it helped me work it out!