I must be really dumb cos my mind is at a blank... how do you open a table when in a form say via a command button?? the wizard only can point me to open queries :/
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:
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"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.