Split Query Form Pop Up

[xyba]

Hi

I'm very new to access and have a question about an issue I'm finding difficult to resolve.

I've created a basic database and within it I have a table, a form (for input) and a split query form for searching for records. However, I want users to be able to input on the form part of the split form to update records but, when they select one particular field (field name Ref1) I'd prefer a combo box that refers to a list in a separate table. I'm guessing this isn't possible though as that field refers to whatever is currently in that field in the main table (or am I wrong?)
If I can't reference a list, I'd like to create a pop up box that shows the list, or even better, a pop up box with a warning if whatever is typed in is not on the list.

Hope I've explained this clearly.

 

[CJ_London]

easy to do, right click on the control and change it to combobox

you'll need to populate the combobox properties such as

rowsource
bound column
column count
column widths

 

[xyba]

easy to do, right click on the control and change it to combobox

you'll need to populate the combobox properties such as

rowsource
bound column
column count
column widths

That worked perfectly...and it was easy.

Thanks so much CJ.