Hello Forum,
I've always learned so much from these forums. And, I have another issue. I've inherited a small db tool and I'm okay with access, so i'm very puzzled because I can't figure out how a form is creating a record. I'm use to just using SQL commands in VBA, prompted by an event like a button push. But, I think I'm working with a data-bound form; but an unsure of the mechanism and where that mechanism is configured.
I added a new field, included that field in the form's record source, and added another invisible textbox bound to the new field through the control source property; the invisible textbox is explained below.
The way it behaves is, after a list box is changed; then a record is created. There are some invisible text boxes, that I made visible. The invisible text boxes are record columns within the table that the form is creating records for. So, the primary key box says (New) when the form opens, and the after the listbox is changed, the primary key appears along with all of the other fields, instead of the one I created. I checked the recordsource table, and my field is not updated.
Any ideas?
Thanks,
CoffeeFunnel