Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to import an Autonumber field in to a textbox in a VB form??

Status
Not open for further replies.

merv805

Programmer
Apr 25, 2003
14
US
I am trying to display the data from a table with the property value as a "autonumber" into a label box on a form inside VB. Do I have to make any necessary conversions of data types to insert this "autonumber" into my label's caption.

I also had another had another question in regards to automatically placing the system's date into a text box on a form.

Can anyone help me??
Thanks for taking the time to help....
 
You should just be able to reference the field by name
similar to label1.caption = RS!RecID

Re the date - in the form load event add the line
text1.text = format(now(),"mm/dd/yyyy") or whatever format you want.

Hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top