Solved

Change to Combo

Posted on 2013-01-15
5
236 Views
Last Modified: 2013-01-15
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
Comment
Question by:Rayne
  • 2
  • 2
5 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 38780619
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
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 200 total points
ID: 38780640
test this

select a value from the combo box and it automatically filter the records
finalTestPleaseRev.accdb
0
 
LVL 61

Accepted Solution

by:
mbizup earned 300 total points
ID: 38780647
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
 

Author Closing Comment

by:Rayne
ID: 38780662
thanks everyone :)
0
 

Author Comment

by:Rayne
ID: 38780712
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now