Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

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
0
Rayne
Asked:
Rayne
  • 2
  • 2
2 Solutions
 
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)Commented:
test this

select a value from the combo box and it automatically filter the records
finalTestPleaseRev.accdb
0
 
mbizupCommented:
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
 
RayneAuthor Commented:
thanks everyone :)
0
 
RayneAuthor Commented:
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now