Combo box fills text box

[Cindi]

Hello again,

I have a form that fills a text box with data according to the selection in
the combo box.

Two questions please:

1) The combo box does not have a control source so when opening the form,
the combo box is empty but the text box already contains the first record.
What do I need to do to either have both the combo box and text box empty on
open or have both contain the first record on open. (If it takes VBA code,
please point me in the right direction as I have not worked with it since
'99).

2) I'm getting a runtime error 3077 on one of the records. I checked it to
see if there were any funny characters within the fields but didn't see any.
What else should I be looking for when encountering this error.

Thank you,

Cindi

[misscrf]

1) check the default value setting in the combos properties.

2) I can't find the error. You might try the msdn knowledge base.
what does the error say besides 3077. Can you check to make sure that
record exists? Are you typing them in? Is the combo limit to list?

[Cindi]

"misscrf" <mi*****@yahoo.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

1) check the default value setting in the combos properties.

2) I can't find the error. You might try the msdn knowledge base.
what does the error say besides 3077. Can you check to make sure that
record exists? Are you typing them in? Is the combo limit to list?

Thanks. I set the default value to " " so now both fields display properly.
As far as the error goes, yes, the record exists and the data was already
there when the project came to me but I do believe it was entered cut/paste.
Once I deleted the record, the problem disappeared. I'll have to see what
happens when it's reentered.