Requey Question?

[Bob V]

On my Switchboard [frmMain] I have a Combobox [cmbTaxWarning] it shows
clients through a query which Clients have not been taxed
My problem is when I go to my Clients form and change him to No Tax then go
back to frmMain my combo box dose not show the change unless I close the DB
and open it............Any Help Please.....Bob

 

[Arvin Meyer [MVP]]

On my Switchboard [frmMain] I have a Combobox [cmbTaxWarning] it shows
clients through a query which Clients have not been taxed
My problem is when I go to my Clients form and change him to No Tax then
go back to frmMain my combo box dose not show the change unless I close
the DB and open it............Any Help Please.....Bob

Add an after update event to your No Tax control on the client form.

Sub NoTax_AfterUpdate()
Forms!frmMain!cmbTaxWarning.Requery
End Sub

 

[Bob V]

Thanks Arvin for you help.....Bob

On my Switchboard [frmMain] I have a Combobox [cmbTaxWarning] it shows
clients through a query which Clients have not been taxed
My problem is when I go to my Clients form and change him to No Tax then
go back to frmMain my combo box dose not show the change unless I close
the DB and open it............Any Help Please.....Bob

Add an after update event to your No Tax control on the client form.

Sub NoTax_AfterUpdate()
Forms!frmMain!cmbTaxWarning.Requery
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com