Save a colum into a variable fro a form

[jker]

I have a form that has a button the gets fired during an ON_CLICK event,

I want to do a SELECT of a table and get the MIN CUSTOMER_ID and store that value into a TXT field that appears on my form


What is happening is that my SQL is creating a table containing the MIN value.... this is not what i want

I want to save the MIN value into a TXT field on my form:

see the attached screen images

Can someone tell me the correct syntax of my SELECT statement?

[Welshgasman]

I would use DMin()

[ranman256]

the select sql will do nothing.
make a query the opens a datasheet to view the select
Qry1 = select * from table where [field]=forms!fMyForm!txtbox

to view the 'select' qry:
docmd.openquery "Qry1"

[jker]

excellent idea!!!!!! I tried it and it gave me exactly what i needed

here is the solution: =DMin("TREATL5_KEY","TREATMENT_LAST5","TREATL5_CUS TOMER_ID=" & "TXTCUSTOMERID")

psuedo code" get the minimum value of TREATL5_KEY from table TREATMENT_LAST5 where the customer id in the table = the value of TXTCUSTOMERID