ellie
Last Activity: Aug 16 '09, 06:59 AM
Joined: Aug 12 '09
Location:
-
I'm from Saudi Arabia, where at? -
Solved: select value from query after cbo selected
Hi I solved this one using a subform (AfterUpdate wouldn't work on my computer) Thanks to ChipR and ezechiel for your help :-) Much appreciated. Now I have Access2007 version sorted out I need to do the same in Access2003 (I may be back for help on this later :-) )
Thanks again Ellie -
Hello (sorry for the late reply. I am in Saudi Arabia and Thurs/Fri is the weekend) Thanks for the responses.
Further information - my query is sorted like this: maintable.from_ dept (group ascending), maintable.docum ent_date (last), maintable.ID (max), maintable.refer ence_number (last)
so I can select the field 'last_reference ' value from the field LastOfreference _number value, based on the unique ID for each record....Leave a comment:
-
Select value from query when cbo item selected
Hello
I have a table (MainTable) with the fields
(PK)ID
(cbo)from_dept
document_date
reference_numbe r
last_reference
I have a query on the first 4 fields that is sorted to give the last reference_numbe r for each from_dept This is the value I need to be automatically displayed in last_reference when the from_dept is selected from it's cbo The idea being that when I enter a new record...
No activity results to display
Leave a comment: