Forms

[Sr Accountant]

I have a form that our Lab Director enters info on, but I am struggling with
two items.

1) I have a drop down list that our director chooses the dr # from.
However, sometimes he types in his own number, which that number is not in my
table, so my reports are not accurate. Is there a way to make it so he can
ONLY pick from the list and can't type anything in there?

2) Also, on this same form, I have a notes section, that the lab director
can type special notes in. However, these notes do not show up in my table,
therefore not showing up on my reports. How can this be resolved? The notes
will need to clear out for a new record, but be stored for the record they
were written about.

I am fairly new on Access, so hopefully this is something simple.

 

[ruralguy via AccessMonster.com]

For problem 1), why not just add hes entry to the table?
Mastering the Combo Box NotInList Event
http://www.fontstuff.com/access/acctut20.htm

As for 2), is the Notes control bound to a field in your RecordSource?

 

[Sr Accountant]

I will try your solution for problem 1. Af for #2..I am not sure what you
mean. Can you give me more details on how I can verify if the recordsource
is bound? Thanks in advance.

 

[ruralguy via AccessMonster.com]

What kind of control are you using for the notes and what is the
ControlSource of the control?

I will try your solution for problem 1. Af for #2..I am not sure what you
mean. Can you give me more details on how I can verify if the recordsource
is bound? Thanks in advance.

For problem 1), why not just add hes entry to the table?
Mastering the Combo Box NotInList Event

[quoted text clipped - 17 lines]

 

[Sr Accountant]

I simply added a text box to my form, and I also added a field in my main
table called notes and made the data type a memo. I him to be able to type
freely any notes he feels he needs to attach.

Where did I go wrong, and how can I fix this?

What kind of control are you using for the notes and what is the
ControlSource of the control?

I will try your solution for problem 1. Af for #2..I am not sure what you
mean. Can you give me more details on how I can verify if the recordsource
is bound? Thanks in advance.

For problem 1), why not just add hes entry to the table?
Mastering the Combo Box NotInList Event

[quoted text clipped - 17 lines]

I am fairly new on Access, so hopefully this is something simple.

 

[ruralguy via AccessMonster.com]

Just set the ControlSource of your TextBox to the Memo field. That should be
all it takes. It is on the Data tab of the properties sheet for the TextBox.
It should be a ComboBox that lets you select fields from the RecordSource of
the form.

I simply added a text box to my form, and I also added a field in my main
table called notes and made the data type a memo. I him to be able to type
freely any notes he feels he needs to attach.

Where did I go wrong, and how can I fix this?

What kind of control are you using for the notes and what is the
ControlSource of the control?

[quoted text clipped - 8 lines]

 

[Sr Accountant]

Thank you....everything is working great now.

Just set the ControlSource of your TextBox to the Memo field. That should be
all it takes. It is on the Data tab of the properties sheet for the TextBox.
It should be a ComboBox that lets you select fields from the RecordSource of
the form.

I simply added a text box to my form, and I also added a field in my main
table called notes and made the data type a memo. I him to be able to type
freely any notes he feels he needs to attach.

Where did I go wrong, and how can I fix this?

What kind of control are you using for the notes and what is the
ControlSource of the control?

[quoted text clipped - 8 lines]

I am fairly new on Access, so hopefully this is something simple.

 

[ruralguy via AccessMonster.com]

Outstanding! Thanks for posting back with your success.

Thank you....everything is working great now.

Just set the ControlSource of your TextBox to the Memo field. That should be
all it takes. It is on the Data tab of the properties sheet for the TextBox.

[quoted text clipped - 12 lines]