If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Edit a table while in form view
I have a form that has multiple tabs and subforms. On one of the tabs is a subform with a recordsource that is a query. It shows data from a table in datasheet mode. In that table I have a field "Selected" which is a Yes/No field (checkbox). In form view, I want to be able to check the checkbox in the table in the subform. I don't have that field locked, what other settings should I check? Thanks, Akilah |
#2
|
|||
|
|||
Edit a table while in form view
Can you update fields in the query if you open the query by itself? You
need to determine whether it is the form that is locking the fields or the query itself. "Akilah" wrote in message ... I have a form that has multiple tabs and subforms. On one of the tabs is a subform with a recordsource that is a query. It shows data from a table in datasheet mode. In that table I have a field "Selected" which is a Yes/No field (checkbox). In form view, I want to be able to check the checkbox in the table in the subform. I don't have that field locked, what other settings should I check? Thanks, Akilah |
#3
|
|||
|
|||
Edit a table while in form view
I checked the query and it was getting Distinct values. When I removed
distinct, the query was updateable. Thanks. "Pat Hartman" wrote: Can you update fields in the query if you open the query by itself? You need to determine whether it is the form that is locking the fields or the query itself. "Akilah" wrote in message ... I have a form that has multiple tabs and subforms. On one of the tabs is a subform with a recordsource that is a query. It shows data from a table in datasheet mode. In that table I have a field "Selected" which is a Yes/No field (checkbox). In form view, I want to be able to check the checkbox in the table in the subform. I don't have that field locked, what other settings should I check? Thanks, Akilah |
Thread Tools | |
Display Modes | |
|
|