yes, it's possible. since you're using a combo box control to choose the
customer (cboCustomer), it's actually pretty easy. add the two new fields to
your table. in the form design view, go to the combo box and change the
RowSource property to include those two fields. make sure you change the
ColumnCount property to include the additional fields. suggest you also set
the length of the two fields to zero (0") in the ColumnWidth property. the
result is that you've added two columns to the combo box, which hold the
default values for each member, so the values are available for use
elsewhere in the form; and you've hidden the additional columns so they
won't be seen in the combo box's "droplist".
in the combo box control's AfterUpdate event procedure, add the following
code to set the value of the cboMembershipType and Amount controls, as
Me!cboMembershipType = Me!cboCustomer.Column(n)
Me!Amount = Me!cboCustomer.Column(n)
you'll have to replace the "n" with the correct column index number for each
value. the columns in combo box controls are zero-based, so the first column
(counting from left to right) is 0, the second column is 1, the third column
is 2, etc.
hth
> Here's one I could use some assistance with:
>
[quoted text clipped - 11 lines]
> Thanks very, very much. This forum is wonderful. My wife is starting to
> think I'm a programmer or something. ha ha :)
scs - 19 Feb 2006 20:12 GMT
Very cool! Thanks that worked great and will be very handy for other things
too.
> yes, it's possible. since you're using a combo box control to choose the
> customer (cboCustomer), it's actually pretty easy. add the two new fields
[quoted text clipped - 44 lines]
>> Thanks very, very much. This forum is wonderful. My wife is starting to
>> think I'm a programmer or something. ha ha :)
tina - 19 Feb 2006 20:17 GMT
you're welcome; yes, it's a handy little trick. :)
> Very cool! Thanks that worked great and will be very handy for other things
> too.
[quoted text clipped - 47 lines]
> >> Thanks very, very much. This forum is wonderful. My wife is starting to
> >> think I'm a programmer or something. ha ha :)