How to get some Fileld from Query to a string?

[sasolini]

Hey,

Can someone pls tell me how can i get data from query to a string so i can use it in my VBA code?

I have a query that basicly creates me a uniqeu code and i need that code when i write new record in datasheet form? For example:

I have Query1 that has a field1 with data "AASSFF"
Now i need that data in my Table1 field1

THX, S

 

[ScottGem]

Use a DLookup