Rabu, 25 Mei 2011

[MS_AccessPros] Selecting a record set with a combo box

 

Hi all,

I created a form with a sub form to edit / enter data into two tables. Everything works great and I can edit / add records and they save fine.

My problem will be when the tables get several hundred entries. I need to be able to select the entry I want to edit from a drop down box.

The two forms are linked by MemberID,..the main forms record source is

the main table and the subform is a select statement of other table.

If I change the memberID field to a combo box, and add a select statement, it will list the ID's but will not allow me to select one.

What am I not doing?

Thanks, Steven

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar