Search : in
By :

Access 2003 VBA Idiot

Last answer on Jun 9, 2009 12:27:09 pm BST msreed, on Mar 9, 2009 7:21:26 pm GMT 
 Report this message to moderators

Hello,
as the title suggests, I'm a VBA idiot. I don't know jack about it. other than to create a macro and convert it. here's my problem:

I created a form to input values into my table. during the creation of this form, I created 2 drop-down boxes and manually inputted the drop values (meaning, I did not link the drops to a different table) and I have a txt box as well on this form.

the values in the 2 drops are:
drp1 = values 1-9
drp2 = low, medium or heavy

now the txt box is a number (i.e: 2.3, 4.4, 8.0....etc...) the value of the txt box is dependant on what the 2 drop downs are. for example...drp1= 1, drp2=low then the txt box would be 3.0.

my question is, how can I have the value for the txt box automatically populate, depending on what is selected with the 2 drop-downs?

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Access 2003 VBA Idiot » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
How to use a driver ODBC 32 BITS under the Window 2003(64 bits)? ShowHow to use a driver ODBC 32 BITS under the Window 2003(64 bits)? You have a Windows 2003 server (64-bits) and you want to use a 32 bits ODBC driver: one that is usually found in the administrative panel for ODBC on Windows or an external...
[VBA: VB6] Using excel from another application Show[VBA: VB6] Using excel from another application Here is a little routine to call Excel from VB6 or another Office application. Paste in a general module (eg Module1) In VBA>> Insert>> Module and paste in the window ... In VB6>>...
Download File Access Helper ShowFile Access Helper is a security software to control your file access. It has been created by Godsw, Inc. It can block and refuse access to files and registry keys on your computer. You cannot launch, copy, open, modify, remove or search documents...
Random access memory (RAM or PC memory) ShowTypes of random access memory There are generally two broad categories of random access memory: DRAM memories (Dynamic Random Access Module), which are inexpensive. They are used essentially for the computer's main memory SRAM memories (Static...
WPA - WiFi Protected Access ShowIntroduction to WPA WPA (WiFi protected Access) WiFi network security solution offered by the WiFi Alliance, in order to fill gaps in WEP. WPA - WiFi Protected Access WPA is a "light" version of the 802.11i protocol, which relies on...
Sharing and permissions in Windows NT ShowIntroduction to folder sharing Sharing allows resources to be designated as being available to all users over a network. When a folder is shared, users can log into the folder from across the network and access the files within, as though the...

1

 morris, on Jun 9, 2009 12:27:09 pm BST

Is your problem solved yet?

Ik don't quit understand your value for the textbox

Grtz

Morris

Reply to morris