How to populate a text box and field based on combo box value? (1 Viewer)

Minty

AWF VIP
Local time
Today, 09:43
Joined
Jul 26, 2013
Messages
10,353
Glad you sorted it - I was trying to figure out how to word my reply to steer you in the right direction.

Me. is used to refer to the current form object. When you use it in the VBA editor you get Intellisense assistance to pick up the right control names, hopefully !

If you can while you are still on the learning curve try and get into the habit of renaming your controls on forms so they are different to the defaults of the field name.
e.g. if your Field name is BudgetRate then call your control txtBudgetRate this makes sure you refer to the control rather than the field.

In fact a naming convention is a great thing to adopt full stop. http://access.mvps.org/access/general/gen0012.htm
 

Gasman

Enthusiastic Amateur
Local time
Today, 09:43
Joined
Sep 21, 2011
Messages
14,038
I am guilty of that I'm afraid, especially when I use the wizards to create a form based on table or query, so I thought 'why not write something to rename them'?

Created my own little program and then discovered this
:banghead:
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 09:43
Joined
Jul 9, 2003
Messages
16,243
I used to have an addin that would do this, lost it along the way, so that code will be very useful thank you!

Sent from my SM-G925F using Tapatalk
 

BadBoy House

Registered User.
Local time
Today, 09:43
Joined
Oct 8, 2009
Messages
54
Hi all. Just wanted to come back and say thanks again for all the assistance with this project.

We went live with the database about six weeks ago and it turned out to be a big success. No problems whatsoever and the introduction of the database has made a big difference to the organisation of jobs within the office.

Thanks again.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:43
Joined
Oct 29, 2018
Messages
21,357
Hi all. Just wanted to come back and say thanks again for all the assistance with this project.

We went live with the database about six weeks ago and it turned out to be a big success. No problems whatsoever and the introduction of the database has made a big difference to the organisation of jobs within the office.

Thanks again.
Hi. Congratulations! Good luck with your project.
 

Users who are viewing this thread

Top Bottom