Nonreactive Form Objects

[justphilip2003]

I have a Form,Button Mania, that I am using to study the various design objects. I have three such inserts that are nonreactive to cursor selection. (1) The first is a ComboBox that I have compared Property Sheet settings to a working example, the notable differences are field names and associated Tables, neither have EPs. The drop down, two column display appears as expected. The selected record does not highlight or insert into my main table. (2) The second is a Check Box. Like (1) it is totally nonreactive. It is not inside an option frame nor does it have an EP. (3) The third is a List Box. The box fills with the appropriate choices, but again the selected record does not highlight or insert into my main table. I reconstructed this List Box twice, making certain that the appropriate options, fields and tables were selected. It has no associated EP. Is it possible that there is a commonality between the three objects? TIA Phil

[rzw0wr]

Can you upload a copy and we will take a look.


Dale

[Missinglinq]

How is the Form's AllowEdits Property set? Set to 'No' you'll have the very behavior you're experiencing.

Linq ;0)>

[justphilip2003]

Well I can't explain it, but I found a partial answer. I can't review old records and use the newly created objects! The work just fine on new records. Must have something to do with earlier record non existing fields!? TIA Phil

[justphilip2003]

How is the Form's AllowEdits Property set? Set to 'No' you'll have the very behavior you're experiencing.

Linq ;0)>

Thanks for the response! I searched all property sheets in question and found no entry "AllowEdits Property." Is there another area to search? I suspect that Access 2010 switched off this field for some reason! Phil

[Missinglinq]

In Form Design View, with the Form itself selected, go to Properties - Data and halfway or so down you should see

Allow Additions
Allow Deletions
Allow Edits

Your additional information, above, would tend to support AllowEdits being set to No as the culprit, here. With an existing Record, attempting to use these Controls is 'editing.' Using the Controls on a New Record, on the other hand, is not 'editing.'

Change AllowEdits to Yes and everything should work as intended. Otherwise you'll really have to Zip your file up and attach it here for us to look at it.

Linq ;0)>

[Missinglinq]

The thread has been marked as "Solved." I take that you found the AllowEdits Property of the Form and set it to 'Yes;' is that correct?

Linq ;0)>

[justphilip2003]

Yes Sir! If an expert states it's there, then by golly, I will search until I find it. The problem with being a beginner, I don't always know where to look. Thanks for your patience! This button Mania Form exercise has been a good idea. My current problem is resolving the round "Option Button" non response to a click EP. Phil