need to select value from maintable field

[ellie]

Hello

I have a table (MainTable) with the fields
(PK)ID
(cbo)from_dept
document_date
reference_number
last_reference

I have a query on the first 4 fields that is sorted to give the last reference_number 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 I select from_dept and the last_reference for that from_dept pops up automatically and I add the next sequential value into reference_number
ad nauseaum

I have attached the file if someon can have a look and for me - I am now wondering after trying lookups, queries and failing to get codes written properly if I need another table into which the reference_number is entered rather than finding the data from the MainTable ???

Does anyone have any ideas? If you look at query_reference the value I need to be seen in last_reference is LastOfreference_number.

I just can't get this last bit sorted out.

[ellie]

I figured this one out - I used a subform rather than AfterUpdate (this doesn't work on my computer for some reason)

Thanks.

[RuralGuy]

That's great! Do you want to go ahead and use the Solved thread tool?