"Recordset not Updateable"

S

Sara

I have a form I have created that is supposed to be filling in information on
3 separate tables. However, whenever I try to change any information that
would be filling in on any of the 3 forms, it says "recordset not
updateable". I'm obviously doing something wrong but I can't figure out what
it is as there is little information regarding forms. Here's a brief
explanation of the 3 tables:

Main Table: Vacant position information
Table 2: I wanted to be able to maintain a record of the position's previous
information whenever something was changed. Through trial and error I learned
that with unbound text boxes, when I enter information and scroll through the
records in my form, the information is on all the records, so I created a
table to hold that information.
Table 3: Position status information. A separate table designed to hold a
position's status.

Any help would be greatly appreciated.
 
G

Golfinray

If your form is not updateable, that means your table or query you base the
form on is not either. Look for the arrow and asterisk highlighted at the
bottom. If it is not highlighted, it is not editable. There are some
workarounds.
 
S

Sara

All of them have the asterisk. I think I might have figured a way around it.
I just created a subform instead. Thank you, though! :)
 

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

Top