Edit a bound field - strange occurance

A

Aaron

I have been racking my brain trying to solve this one:

Form bound to a query
When you click on a record in the "Booked By" field on the form, it pulls up
a bound form to a query with that record displayed. All of the records are
locked, except the "Booked By" text box. When I first created this, it worked
fine. I was able to edit the "Booked By" text box.
I saved the database, went home for the day, open it up today, and now I
cannot edit the Booked By text box. I have not changed a thing. I tried
unlocking all of the records on the form.
Is there any reason for this. How can I get it back to being editable?

Basically, I want someone to click on a record, and type in there name to
state that they have that record held.

Properties of the text box:

Control source: [name of field]
Enabled: Yes
Locked: No
Filter lookup: Database default


Any help would be appreciated.
 
S

Sharkbyte

You may also want to check the form properties, particularly Allow Edits,
Allow Additions, if you are adding information to the form.

Sharkbyte
 
A

Aaron

Thank you for the quick response.
Yeah, those were ok.
I actually figured out a way to make a make-table query and bound the forms
to that instead of queries. That may be why I was unable to edit the field.

What I don't understand is why it worked yesterday, and not today.

Oh well, got it working.



Sharkbyte said:
You may also want to check the form properties, particularly Allow Edits,
Allow Additions, if you are adding information to the form.

Sharkbyte



Aaron said:
I have been racking my brain trying to solve this one:

Form bound to a query
When you click on a record in the "Booked By" field on the form, it pulls up
a bound form to a query with that record displayed. All of the records are
locked, except the "Booked By" text box. When I first created this, it worked
fine. I was able to edit the "Booked By" text box.
I saved the database, went home for the day, open it up today, and now I
cannot edit the Booked By text box. I have not changed a thing. I tried
unlocking all of the records on the form.
Is there any reason for this. How can I get it back to being editable?

Basically, I want someone to click on a record, and type in there name to
state that they have that record held.

Properties of the text box:

Control source: [name of field]
Enabled: Yes
Locked: No
Filter lookup: Database default


Any help would be appreciated.
Click to expand...
Click to expand...
 
Top