related combo boxes

[sara88m]

hello guys
I have a problem in my database
I have a table with 12 fields 3 of which are combo boxes
I designed a form and wrote code (after update event) to relate the 3 combo boxes
now, when I fill a record and click on enter to go to the next record, the 3 combo boxes of the new record is auto filed based on the previous record!
in this way I can have the same data in the 3 combo boxes for all my records.


Anyone can help me??

[Homegrownandy]

Put this in the code for the "enter". Change the names to suit.

Me.Combobox1 = Null
Me.Combobox2 = Null
Me.Refresh

[sara88m]

thanks dear Homegrownandy
on which field should I add this code? you mean on "on enter" in the properties of that field?

[Homegrownandy]

you said " click on enter to go to the next record" I assumed you created a command button that did something. Is that correct?

[sara88m]

actually I want to be able to go to a new record. with a button or by clicking on enter key, after I fill the last field of the record. the both are OK.

[sara88m]

Your command makes the very data of that record Null/empty, doesn't make a new empty record for me to enter the data of the next record..

[sara88m]

Your command makes the very data of that record Null/empty, doesn't make a new empty record for me to enter the data of the next record..

[Homegrownandy]

create a button that you will press when you have finished data entry. You can apply some validation to your data here so you get what you want. you can save the record and open a new one. you can refresh combo boxes. whatever you want.

you said : "now, when I fill a record and click on enter to go to the next record, the 3 combo boxes of the new record is auto filed based on the previous record" so the code I provided will clear those entries.

[sara88m]

Thank you dear friend
I said that in a case that I do data entry in rows in one form without a button. with a button, I tried your code but made the very record empty, would you please help me with the both methods ? or either which you can

[Homegrownandy]

this will close the form you're on and reopen it. If your textboxes /combo boxes are bound then the record will save.

DoCmd.Close acForm, "your form name"
DoCmd.OpenForm "your form name",,,,acFormAdd

See how that works.

[ssanfu]

<snip>I have a table with 12 fields 3 of which are combo boxes<snip>

It sounds to me like you have 3 lookup FIELDS in the table. Bad idea......
See
The Evils of Lookup Fields in Tables
http://access.mvps.org/access/lookupfields.htm

Also
The Ten Commandments of Access
http://access.mvps.org/access/tencommandments.htm


The combo boxes should be controls on a form......