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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Controls on form for input to two tables
- Thread starter cac2
- Start date
FoxProProgrammer
Programmer
You could create a recordset based on the other table and store the value.
Dim db as Database
Dim rs as Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("OtherTableName", dbOpenDynaset)
rs.Edit
rs!checkboxname = value
rs.Update
rs.Close
db.Close
Dim db as Database
Dim rs as Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("OtherTableName", dbOpenDynaset)
rs.Edit
rs!checkboxname = value
rs.Update
rs.Close
db.Close
- Status
Similar threads
- Locked
- Question
