Linking form to a table

[Techfi]

i have a form for table A. One of the fields I will be filling in for table A. needs to be a value from field A on table B. How do i get the drop down to show that data?

 

[Dugantrain]

Have you tried the Combo Box Wizard? It should have everything you need (Data Source, Control Source) built in.

 

[anvil19]

Hey Techfi

All that is required here is a SQL statement that calls the data from TableB. To do this add the following to the Row Source space in the propertis window:

"SELECT FieldName from TableB ORDER BY FieldName" (Just add the correct field and Table names)

Dugantrains' post to use the Combo Box wizard will work just fine too. It pops up automatically when you add a combo box to a form.

Select option 1 "I want the combo box to look up values in a table or query" and select the table or query you are after (TableB in this case) and then select the Field you are after (FieldA here) and tada!!

anvil19

 

[Techfi]

all i can get it to do is show the first column if the table i want.(there are only 2 columns in this table, and I want the second) I have the control source set for the column i want, i have the row source type set for table/query, and row source set to the table i want, what am i missing?

 

[anvil19]

Hi Techfi

What you are seeing is the entire table, but because your column count is 1 you only see the first field.

You must just add the SQL statement to the row source space, and leave the control source space empty.

anvil19
[/quote]

 

[anvil19]

Hi Techfi

What you are seeing is the entire table, but because your column count is 1 you only see the first field.

You must just add the SQL statement to the row source space, and leave the control source space empty.

anvil19