VB help

[prose7777]

I have a query calling data from a table with 4 diffrent coloms and 50 records which decend by date.

I want to open the query in VB extract a specific record by date and then fronm the record take a specific colom and send it to a textbox in the form here is what i have so far

Private Sub Command16_Click()
Dim stDocName As String

stDocName = "4RK11509 Query"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.GoToRecord DoCmd.GoToRecord, , acLast

End Sub

Any Suggestions

 

[Mile-O]

Getting an understanding of DAO or ADO will help you achieve what you want.

 

[prose7777]

vb help

but can i extract a specific field from the record into a text box?