Displaying memo field on a form

[Jerry in the Desert.]

I asked this the other day and thought I had it, but alas, I am a tard.

I am displaying information on a form (Access 2003). I have 3 combo boxes
and a memo field. Call them C1, C2, C3, M1. The Values displayed in C2 are
based on the selection of C1, the values in C3 are based on the values of C1
and C2. I accomplish this using the After Update function requery Item data
in VB. the Memo field (M1) will be based on the values selected in C1, C2,
and C3. I can't make the memo field display. When I use the next record
button at the bottom of the form it will display, but I don't think the users
will want to scroll through all the records to find what they are looking
for. The sub form that is embedded in this form will be filled out, but
these 4 fields are static and are for display only. Please help.

Thanks

 

[Mr. B]

I asked this the other day and thought I had it, but alas, I am a tard.

I am displaying information on a form (Access 2003). I have 3 combo boxes
and a memo field. Call them C1, C2, C3, M1. The Values displayed in C2 are
based on the selection of C1, the values in C3 are based on the values of C1
and C2. I accomplish this using the After Update function requery Item data
in VB. the Memo field (M1) will be based on the values selected in C1, C2,
and C3. I can't make the memo field display. When I use the next record
button at the bottom of the form it will display, but I don't think the users
will want to scroll through all the records to find what they are looking
for. The sub form that is embedded in this form will be filled out, but
these 4 fields are static and are for display only. Please help.

Thanks

Jerry,

I am not clear as to what is populating the Memo field. If your memo
field is bound to a recordset then you may just need to refresh you
form after the final selection is made from C3.

Me.Requery

If your memo field in Unbound then you could get the value for the
memo field from a column in your C3 combo box or which ever combo box
would have the memo field included in its record set.

If you can provide just a little detail as to the source of the memo
field prehaps we can help a little more.

HTH

Mr B

 

[Jerry in the Desert.]

The memo field is prepopulated in the table. In this table, C1, and C2 can
have duplicate values, C3 is unique to C1 and C2, but there can be duplicate
C3. The combination of C1, C2, and C3 is unique and the memo field is
unique to this combination. I am using the memo field because I need to
display more than 255 chars.

 

[Mr. B]

The memo field is prepopulated in the table. In this table, C1, and C2 can
have duplicate values, C3 is unique to C1 and C2, but there can be duplicate
C3. The combination of C1, C2, and C3 is unique and the memo field is
unique to this combination. I am using the memo field because I need to
display more than 255 chars.






- Show quoted text -

Jerry,

If you are not already doing so, create a query or an sql statement as
the record source for your form. You can then use a reference to each
of the combo boxes as the criteria for each of the fields represented
by the combo boxes.

Then in the after update event of each of the combo boxes you would
need to check to be sure that there was a value selected for all three
combo boxes and then just Requery your form.

I would most likely put the code to check for the valid data entry in
a function and then call the function from the After Update event of
each combo box.

Here is some "air" code that could be used for the Function:

Function ChkForReqData()
If not isnull(me.C1) and not isnull(me.C2) and not isnull(me.C3)
then
Me.Requery
End IF
End Function

Then in the After Update event of each of your combo boxes use the
following statement to call the function:

ChkForReqData

HTH

Mr B