form focus and record jumping trouble

[dat_guy]

Hi all,

My problem might be simple but i dont know what to look for.

I made a simple form based on a query for the purpose of changing/adding/deleting records from my main table. I have a cmb that populates the form with data for the record selected. That works fine.

I made a new record button, that seems to be working fine also. The problem is when I click on the new record button, and type in the new entry in the cmb, after I press the <tab> key(or simply click in the next txtBox), focus goes back to the cmb ( even though I set its tab order to last for testing purposes ) and the form gets populated with data from the first record in my table, and navigation controls say record 1. My entry stays in the cmb though.

Prolly something simple, I just dont know what to look for.

thx in advance
dat_guy

 

[dcx693]

If you combo box is used to find records then how are you also using it as a "bound" control when you enter new records?

 

[dat_guy]

/slaps his forehead at his own sillyness

Hmmm good question.

My users need the option to modify current records, or add new records. They also want the form to be auto-populated if a current record exists(via cmbBox).
So what might be the best way to go about doing this? Form/subform? or 2 separate forms? Or am I way off here? I'm comfortable with and sometimes even prefer VB.

thx for the quick help

dat_guy

 

[dcx693]

You can use the same form, you just should not use the same combo box for searching and for inputting data. You need two combo boxes in this case.

 

[dat_guy]

Thanks a ton. It works splendidly.

dat_guy