NewBie Problem

[rushB]

bring you form in design view.
click on the combobox.
on it's Event, AfterUpdate, add some code

private sub combo_name_AfterUpdate()
Call fncRiskDate
end sub

again, click on the Last Review Date textbox, add code
to its AfterUpdate event:

private textboxName_AfterUpdate()
Call fncRiskDate
end sub

No still no reaction. Would you mind hoping on to my pc via teamviewer or so?

 

[arnelgp]

i don't have teamviewer.
compress your db in Zip then upload it here as attachment.

 

[rushB]

i don't have teamviewer.
compress your db in Zip then upload it here as attachment.

okay will do that
thanks

i don't have teamviewer.
compress your db in Zip then upload it here as attachment.

here is the db

 

[rushB]

i don't have teamviewer.
compress your db in Zip then upload it here as attachment.

if you need the code for Leon it s 1234

 

[arnelgp]

you use the combobox name (combo123).
see the code.

 

[rushB]

you use the combobox name (combo123).
see the code.

oh okay, thanks a lot. Been thinking about that now several hours and not getting it

 

[rushB]

you use the combobox name (combo123).
see the code.

would you mind telling me what the Me.dirty = False command does?

 

[arnelgp]

it simply means that any pending update you make to the record, be it new or just
modifying the old one, all changes will be saved to the table.

its same as executing this:

DoCmd.RunCommand acCmdSaveRecord