Linking Combo Box in table to Combo Box in Form

[marisacoul]

Hi there!



I have a field in my table that it set up perfectly with a combo box and 2 options. However I'd like this field and a field in my form to be linked, and for the same combo box drop down to appear in the form. I would also like this to happen with another field and corresponding form, except that mutiple values to be allowed.

I would like any changes made to the form to appear in the table and vice versa, but for the fields to be working from the same combo boxes.

This has probably been asked and resolved before but I'm new to this, forgive me...

Marisa

[ranman256]

The source query for both, the form and the table, should be the same.
If the field is CreditCardName,
the query should be pulling from the table tCreditCards. (Visa, MC, Discover)
This way BOTH are pulling the same data.

If you are using a form, theres no reason to have the table field be set to a combo box.

[marisacoul]

The source query for both, the form and the table, should be the same.
If the field is CreditCardName,
the query should be pulling from the table tCreditCards. (Visa, MC, Discover)
This way BOTH are pulling the same data.

If you are using a form, theres no reason to have the table field be set to a combo box.

Yes... Maybe I should prevent users from editing the values in the table, and only have them input in the form. Do you know how to do this?

[ranman256]

Make a form menu. They click a Client button that opens the frmClients., etc.
all point and click guided.

[marisacoul]

Make a form menu. They click a Client button that opens the frmClients., etc.
all point and click guided.

Sorry I'm not understanding. How do I create a form menu? Also... when I try to create the dropdown for the form it's only showing one option. This is what I'm putting for row source: "Canada"; "International" and only international is coming up...


Marisa

[ssanfu]

Hi there!

I have a field in my table that it set up perfectly with a combo box and 2 options. <snip>

This is known as a "look up FIELD" (bad), as opposed to a "look up TABLE" (good).

See
The Evils of Lookup Fields in Tables
http://access.mvps.org/access/lookupfields.htm

Also, you might read
The Ten Commandments of Access
http://access.mvps.org/access/tencommandments.htm


Users (IMHO) should NEVER have direct access to tables.