In my form Initial Oder Entry - I have a drop down to choose rep - the text Boxes should update with the Rep First Name and Rep Last name - to match the record from the ComboBox
What am I missing
(zip file attached)
Competent Performer
Windows 7 64bit 
Access 2010 64bit
In my form Initial Oder Entry - I have a drop down to choose rep - the text Boxes should update with the Rep First Name and Rep Last name - to match the record from the ComboBox
What am I missing
(zip file attached)
VIP
Windows 7 64bit Access 2010 32bit
The embedded macro code is not working. The macro WHERE CONDITION references RepID field. There is no RepID field on the main form. Change it to [ID].
I use only VBA, easier to debug.
Why is the RepFirstName a listbox? I deleted it and added a textbox in its place.
Last edited by June7; 01-09-2014 at 08:09 PM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 7 64bit Access 2010 64bit
That is great - on your direction I got it working. What would the VBA look like for say Combo Box: cboRep Record: [RepId]
VIP
Windows 7 64bit Access 2010 32bit
Don't understand. There is no RepID field on form 01InitialEntry. If you want to know the VBA code for the existing macro, there is a tool on ribbon to convert macros to VBA.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Subreport on form seach issues
Form Seach Box-all attempts have failed.
Posting Permissions
Reply With Quote