ComboBox - After Update

[Taff]

HI all,

I have attached a sample copy of my database.

On the form there is a combo box and two text fields.

After a value has been selected from the combo box there are two things that i would like to happen.

In the submission Number field i would like to count all the records from the Exports to ELWa table that have the same Value as that from the Combo box and add 1 to the value.

In the Number of Records field i would like to count all the records from the Learning Activity Dataset table.

Thanks in Advance for the help.


Anthony

 

[Taff]

Attaching it might be useful.

 

[ColinEssex]

Attaching it might be useful.

we're all waiting

 

[Mile-O]

drum roll....

 

[ColinEssex]

getting nervous now - it'll be here any minute

 

[Taff]

Twice,

Tell its Friday!

 

[ColinEssex]

too late - we got bored waiting

 

[Taff]

Need Sleep!!!

 

[Taff]

Hello?

I'll be quicker next time i promise.

 

[ColinEssex]

If you put this code in the AfterUpdate bit of the ComboBox it'll do the 2nd part of your problem.

Me.Number_of_Records = DCount("learn_ID", "Learning activity dataset")

I have to do something else now but the first part of your prob is the same but add a criteria by referencing the Combo.

Col

 

[ColinEssex]

I forgot to add that there's no records in the table and I didn't know which field would contain the same text as the ComboBox selection.

Col

 

[Taff]

Hi Col,

Thanks for that. The field that would contain the duplicate data is Dataset Name (Dataset to Export) in the Exports to ELWa table.