Recent content by newbieVS

@Plog - is creating two forms the only way? That seems really cumbersome. @arnelgp - in the property sheet for my combo box, under data tab, I have bound column set as 1. Doesn't that mean i'm already about to my primary key? Should I set bound column to 0?

Hi, I'm using Access 2010. I have created a table and a form to enter new records into the table. The form is controlled by a combo box. In the combo box, I can enter a new value for the primary key and fill out the rest of the form to create a new record. Alternatively, I can select an...

yep. I'm going to try that and also write the code required to load data. thanks all.

I'm trying to bound my form. It seems I need to set ControlSource. I can find RecordSource but can't find ControlSource. I guess more generally I'm trying to see how I can bound my form to my table?

I agree I don't necessarily want to add a new record everytime I open the form. Basically, what i want to do is that when the form opens up, it doesn't pre-populate the fields. I achieved this by setting Data Entry to "Yes" in properties. Now I've added a listbox on the form that lists the...

Ah I see. I did not have an after update event. The only code I had was to load existing primary keys into the list box. Code was simply what was generated by wizards: Select [primarykey] from [tablename] What code should I put into the after update event?

Thanks ridders. I've created a listbox that loads in primary key (using wizard). However, when I select one of the values in the listbox, it doesn't populate the rest of the forms with the values in the field. How can I get all the other fields in the form to be populated once I select the...

I've got a form connected to a table. Under properties, Data tab, I've set Data Entry to "Yes". This is good because it default the form to a new record when I open it. However, I would also like to have the field in the form that is a primary key to be a drop down menu where I can load existing...