Bbeginner Question...

[Elliott3]

Hi... I have never programmed in VBA before and just trying to get started...
How do I go about selecting records from a table say on the forms load even and place one of the values that is in the result into a text box on the for?

Basically I would like to now how to interact with the table on button clicks "select * form ..." and "insert into ..."

Any suggestions on where to start?

CES

 

[Elliott3]

Set rs = CurrentDb.OpenRecordset("select * from tbl_NextNumber") is the answer that I came to.

CES