autofill depending on other fields input

  • Thread starter Thread starter nydia
  • Start date Start date
N

nydia

I have a form that users enter client meeting
information. There is a report that is printed to bill
for these meeting. There are 2 types of meetings (group
and individual) and in the tbl, i have them as listbox.

Depending on the meetingtype there is a field called group
no. What i want is when the field meetingtype is
individual, i want the groupno to be "none" how can i do
this?
 
To prevent the users from entering a value in the GroupNo
control unless the meeting is for a Group, I would set the
enabled property of the field called groupNo to No in the
design view and write code in the AfterUpdate event handler
of the list box along the following lines

If {yourlistboxname}.Value = "Group" Then
{groupNocontrol}.Enabled = True
Else
{groupNocontrol}.Enabled = False
End If

Hope That Helps
Gerald Stanley MCSD
 
Hi Nydia:
I assume that GroupNo is a text field. In the
after update property of meetingtype, try this:

If me("meetingtype") = "individual" Then
me("groupno") = "none"
End if

Hope This Helps
 
Back
Top