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!
Opening a Table from form...Easy i Bet!!
- Thread starter Ryath
- Start date
What do you mean by "open" a table? For editing? To browse the data visually as in a datasheet or form? The answer you get will depend on your meaning....
To open a table for programmatic editing, you can use recordsets, like this:
and so on - VBA coding.
You can also write and run queries to do updates, etc etc..
If you can be more specific as to your needs, we can be more specfic in our responses.
Jim Hare
"Remember, you're unique - just like everonone else"
To open a table for programmatic editing, you can use recordsets, like this:
Code:
Dim myRST as Recordset
set myRST = CurrentDb.OpenRecordset("foo", dbOpenDynaset)
with MyRST
.MoveFirst
!FieldGuy = "New value"
.Update
.Close
End with
Set MyRST=Nothing
blah, blah, blah...and so on - VBA coding.
You can also write and run queries to do updates, etc etc..
If you can be more specific as to your needs, we can be more specfic in our responses.
Jim Hare
"Remember, you're unique - just like everonone else"
- Status
Similar threads
