By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,645 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,645 IT Pros & Developers. It's quick & easy.

Combo box fills text box

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?

Nov 13 '05 #2

P: n/a

"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.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.