Form Help Please!

S

Shiner452

I have a form with a combo box that pulls records from a query. I wan
the users to be able to enter data into a few of the fields of th
record that has been pulled up. The text boxes seem to be locked and
cannot enter data in them. The 'Locked' property is set to 'no' s
changing that wont help. Is there any way i can make a few of thes
fields editable
 
J

John Vinson

I have a form with a combo box that pulls records from a query. I want
the users to be able to enter data into a few of the fields of the
record that has been pulled up. The text boxes seem to be locked and I
cannot enter data in them. The 'Locked' property is set to 'no' so
changing that wont help. Is there any way i can make a few of these
fields editable?

I suspect that the Query upon which the Form is based is not
updateable. Try opening the Form in design view; view its Properties;
find the Recordsource property on the Data tab; click the ... by it. A
query design window will pop up. Open the Query in datasheet view -
does it have a *> new record icon? If not, see the online help for
"Updateable" or post the SQL view of the query 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

Top