Edit a bound field - strange occurance

[Guest]

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.

 

[Guest]

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

Sharkbyte

 

[Guest]

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.

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

Sharkbyte

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.