marydoyle9
Crckrs9
- Local time
- Today, 21:55
- Joined
- Mar 5, 2003
- Messages
- 17
I've looked at many of the posts that already address this issue... but am still struggling.
I created a form (AddrChg) with New address information (stored in AddrChg table). On the form, the user will be required to select a county (County table) from a list box (County table - has three columns: county number, county name, fax number). I created another field (text box?) on the form that I would like to have auto-populate with the Counties' fax number (...as mentioned, stored on the County table). So, if a user selected Polk county, the corresponding fax number for that row will autmoatically display in the "Fax Number" test box. The data entered in this form will be written to the AddrChg table.
I've tried a few of the things that were on other posts but I am obvioulsy too new at doing this to get it right cuz I have yet to be successful. I don't believe what I need is a cascading combo box. I fthese two foelds need to be bound, how? Do I need to add an event? If so, to which box (field) and what's the event? If I need to add code PLEASE be very specific - I am NOT a VB programmer (so I would need an explanatin on what it is I am adding and to where and how, etc etc etc). If there is something else I need to do, please keep explanation as simple as possible...
Thanks!!!!!
I created a form (AddrChg) with New address information (stored in AddrChg table). On the form, the user will be required to select a county (County table) from a list box (County table - has three columns: county number, county name, fax number). I created another field (text box?) on the form that I would like to have auto-populate with the Counties' fax number (...as mentioned, stored on the County table). So, if a user selected Polk county, the corresponding fax number for that row will autmoatically display in the "Fax Number" test box. The data entered in this form will be written to the AddrChg table.
I've tried a few of the things that were on other posts but I am obvioulsy too new at doing this to get it right cuz I have yet to be successful. I don't believe what I need is a cascading combo box. I fthese two foelds need to be bound, how? Do I need to add an event? If so, to which box (field) and what's the event? If I need to add code PLEASE be very specific - I am NOT a VB programmer (so I would need an explanatin on what it is I am adding and to where and how, etc etc etc). If there is something else I need to do, please keep explanation as simple as possible...
Thanks!!!!!