Unbound combo or text boxes fail to work in Form Header Section

[ScottXe]

I tried to put some unbound combo or text boxes in the header section of a continuous form. All boxes are not working until I move them to detail section. All boxes in the form header section have the settings: Enabled is set to Yes and Locked to No. Is there any construction restricting me to use unbound boxes in the header section of a continuous form? Thanks!

[Bob Fitz]

What is the purpose of these unbound controls?

[orange]

You may get some insight from this example from Allen Browne.

[Missinglinq]

...Is there any construction restricting me to use unbound boxes in the header section of a continuous form...

Not per se; I think the important thing, here, lies in the answer to Bob's question.

Linq ;0)>

[ScottXe]

What is the purpose of these unbound controls?

The boxes are used to input the key words for searching the records.

[Missinglinq]

The Header Section is really the correct location for this kind of thing! How, exactly, are they 'not working?' Are you getting error messages? Incorrect results? No results or nothing happening at all?

Saying that they 'work' after moving them to the Detail Section makes me wonder if their working depends on a value or values found in one or more Fields in the Record. If this is the case, perhaps the problem is that there has to be a Record that is selected before running the search code.

The Allen Browne article orange cited is an excellent tutorial for this sort of thing; perhaps you can find your answer there.

Linq ;0)>

[ScottXe]

Thanks for all responses. I have resolved it by setting to yes on Allow Edits property.

[Missinglinq]

...How, exactly, are they 'not working?'...

So, by 'not working' you meant that you could not actually make a selection from the Combobox. This demonstrates why you have to be as detailed as possible when describing a problem! If you'd made that clear, in your original post, we could have helped you immediately!

The Access Gnomes, in their infinite wisdom, look at the act of using of a Combobox as a form of editing a Record; hence if AllowEdits is set to No/False, they cannot be used!

FYI, if you need to

• Use a Combobox
• Not allow editing of Records

the workaround is to set AllowEdits to Yes/True and Lock or Lock and Disable all of the Controls on the Form.

Linq ;0)>

[ScottXe]

So, by 'not working' you meant that you could not actually make a selection from the Combobox. This demonstrates why you have to be as detailed as possible when describing a problem! If you'd made that clear, in your original post, we could have helped you immediately!

The Access Gnomes, in their infinite wisdom, look at the act of using of a Combobox as a form of editing a Record; hence if AllowEdits is set to No/False, they cannot be used!

FYI, if you need to

• Use a Combobox
• Not allow editing of Records

the workaround is to set AllowEdits to Yes/True and Lock or Lock and Disable all of the Controls on the Form.

Linq ;0)>

Hi Linq,

Thanks for your reply. I used to set the Allow Edits to No for read-only form but never known about the effect to other unbound boxes in form header. Actually, there are a couple of ways to make a read-only form and unsure the differences amongst them.

Allow Edits = No
Recordset Type = Snapshot
Data -> Locked = Yes

Thanks!

[Missinglinq]

...I used to set the Allow Edits to No for read-only form but never known about the effect to other unbound boxes in form header...

Just to be clear...the fact that the unbound Controls were in the Form Header had nothing to do with their not functioning...you had to have turned AllowEdits back on when moving them to the Detail Section and finding them magically functioning. It's easy to do a couple of different things without realizing it, when clawing at straws.

...there are a couple of ways to make a read-only form and unsure the differences amongst them...

Allow Edits = No
Recordset Type = Snapshot
Data -> Locked = Yes

See if this helps:

Allow Edits = No

Records cannot be Edited
New Records can be Added
Records can be Deleted
Comboboxes will not work

Recordset Type = Snapshot

Records cannot be Edited
New Records cannot be Added
Records cannot be Deleted
Comboboxes will work


Data Controls-> Locked = Yes

Records cannot be Edited
New Records can be Added
Records can be Deleted
Comboboxes will work

Linq ;0)>