Try changing the rowsource property during afterupdate event.
*********** REPLY SEPARATOR ***********
On 6/27/2005 at 3:52 PM torres0157 wrote:
>Can someone Help?
>
>I have a Commission Form and use a query for filling in data . The
>Commission form has 6 lines (max) of information which includes the
>salesperson who made the sale. The other (5) Info. is other employees
>who will recieve a commission. Employee name, ssn, location, type.
>I was able to let the users (thru ComboBox) select what they need but
>this could cause errors.
>Is there a way to auto populate all the fields if the user selects
>an employee name (thru ComboBox) for each empolyee who is to recieve a
>commission.
>
>Can someone Help...
>
>Thanks.. Mando
>
>
>
>
>
>
>
>Please zip all files prior to uploading to Files section.
>Yahoo! Groups Links
>
>
>
Harold Glenn P. Minerva, ECE
Sr. MIS Researcher
Cebu Port Authority
CIP Complex, North Reclamation Area, Cebu City
Telephone No.: 63 32 2321461 loc 36
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
