Need to update a checkbox on another table

[StanJx]

I have a form called frmMaster(tblMaster),n which there is a combo box called cmbRequestID (The combo box is populated from a related table called tblRequest). The table tblRequest has a field called Done which is check box. I need to update this check box when I am saving a record on frmMaster. Would appreciate some help on show i could get this done.

 

[MacroAlan]

Assuming that there is an update process for tblMaster i.e. it is not a bound table, run a recordset to update to change Done from False to True.

sqlStr="SELECT * FROM tblRequest WHERE RequestID=me.cmbRequestID.value"
Set RSreq=db.openrecordset(sqlStr,dbopendynaset,dbseeChanges)
   rsreq.edit
    rsreq!Done=true
   rereq.update
set RSreq=nothing

Alan

 

[Andrzejek]

Or you can simply execute this statement:

UPDATE tblRequest
SET Done = True
WHERE RequestID = me.cmbRequestID.value

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[dhookom]

In code:

Currentdb.execute "update tblRequest set Done=true where RequestID = " & Me.cmdReqestID

Duane
Hook'D on Access
MS Access MVP

 

[StanJx]

frmMaster is bound to the table tblMaster

 

[dhookom]

StanJx,
You were provided with several suggestions. Did any of them work? Did you get any errors? What were your results?

Duane
Hook'D on Access
MS Access MVP

 

[StanJx]

Yes.. All good.. Had to make some changed and do something different as my data types were different but was able to use those methods to do this.. Thanks for all who replied.. Appreciate it a lot.

 

[Andrzejek]

So which method did you end up using that works for you?

It would be nice for others - who may search this site - to know what worked for you.


Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[StanJx]

Andrejek, I added a new dialog form and used the Currentdb.execute "update tblRequest set Done=true where RequestID = " & Me.cmdReqestID statement.