Change to Combo

Hello All,

Need a small favor –
Can you guys help me to Change the “ShipName” field in the form to a drop down instead of text input

thanks
finalTestPleaseRev.accdb
RayneAsked:
Who is Participating?
 
mbizupConnect With a Mentor Commented:
Here's the same think with your new sample...

All you need to do is right-click the textbox and select "Change to combobox"

Then set the combobox's rowsource property to:

SELECT DISTINCT [Ship Name] FROM tblSource
finalTestPleaseRev--1-.accdb
0
 
mbizupCommented:
Try this -

It's based on a sample from your earlier question, but I got there too late.

Look at the code behind the command button.
finalTestPlease---Copy.accdb
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
test this

select a value from the combo box and it automatically filter the records
finalTestPleaseRev.accdb
0
 
RayneAuthor Commented:
thanks everyone :)
0
 
RayneAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.