Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-17-2017, 10:19 AM   #1
Gismo
Newly Registered User
 
Join Date: Jun 2017
Posts: 78
Thanks: 14
Thanked 0 Times in 0 Posts
Gismo is on a distinguished road
Show cuuency based on combobox

Hi All, I have for orders form where I can select the currency, USD, EUR, ZAR... from a combo box, I want the currency selected to show in my orders detail when entering the cost of the unit. any idea how to accomplish this?

Gismo is offline   Reply With Quote
Old 07-17-2017, 10:59 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 2,361
Thanks: 0
Thanked 512 Times in 498 Posts
Ranman256 is on a distinguished road
Re: Show cuuency based on combobox

you need a tCurrency table with all the denoms.
set the source of the combo to this table, you can also set the default to USD if needed.
set the target of the combo to the field in the OrderDetail table.
Ranman256 is offline   Reply With Quote
Old 07-17-2017, 11:01 AM   #3
Gismo
Newly Registered User
 
Join Date: Jun 2017
Posts: 78
Thanks: 14
Thanked 0 Times in 0 Posts
Gismo is on a distinguished road
Re: Show cuuency based on combobox

Lol. Thank you but you will have to give it to me in plain english. Sorry

Gismo is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Show one of many buttons based on combobox. Or open specific form based on combobox. jmkeuning Forms 6 09-08-2016 11:40 AM
based on combobox one selection , combobox two must display those values compu General 1 07-29-2012 11:02 PM
Auto-Assign a value to a combobox based on a previous combobox entry sguan Forms 1 07-15-2011 09:36 AM
Filter Subform ComboBox based on Master Form ComboBox selection azammalick Forms 1 12-16-2009 12:27 PM
show values in one Combo box based on values selected from another combobox Emma Modules & VBA 3 11-15-2000 03:47 AM




All times are GMT -8. The time now is 12:52 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World