Table link

  • Thread starter Thread starter DH010010
  • Start date Start date
D

DH010010

In a previous post i asked about displaying data in a form from two different
tables. I was told to likn the tables using a query. i have done that and the
data displayes how i want it to however the form used to allow me to add new
records but now it dosent. i would only let me look at loaded ones. help....
 
Your query is not editable. Look at the bottom and the arrow and asterisk is
probably grayed out. That means it is not editable. What I do in that case is
to convert the query to a make-table query (under Queries) then run it to
make a new table and the new one will be editable. Change to query back to a
select query after you make the new table.
 
You must log in or register to reply here.

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

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Linking to external databases on startup 2
Transfering form data 3
Add form with subform not working 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Using Collect Data with Related Tables 3
linking tables 3
Linked Table Problem 5

Back
Top