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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I have a need to create a single-re

Status
Not open for further replies.

iamchemist

Programmer
Mar 2, 2009
73
US
I have a need to create a single-record table, where there is just one row of fields, that gets written over top of over and over again from a form.

Currently, my Table just keeps on growing, and I'm using a query to select only the row with the maximum key number. But this seems like a sort of kludgey approach.
 
You can add ID field, set it as key, set value to 0, set validation to 0. This table can have only one record. Remove navigation bar from the form.

combo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top