M
Mr-Re Man
I'll try to explain this the best I can.
I have a form with numerous fields on and the user will input details in an
order set-up by the tab.
Purpose of form: Logs invoices for payment, however, any utility bills (gas,
elec) have to have their usage recorded. These details are to be logged on a
separate form.
My question to the experts is: If the user inputs into the account number
field [AccountNo] on the main invoice screen a value that matches an account
number in the utility table, can a button be displayed [invisible if no
match] when there is a match and then take them to that specific record in
another form.
Finally, I don't want the button to be displayed until they have selected
which type of utility it is [cboUtilityType].
Hope thats clear.
tia
I have a form with numerous fields on and the user will input details in an
order set-up by the tab.
Purpose of form: Logs invoices for payment, however, any utility bills (gas,
elec) have to have their usage recorded. These details are to be logged on a
separate form.
My question to the experts is: If the user inputs into the account number
field [AccountNo] on the main invoice screen a value that matches an account
number in the utility table, can a button be displayed [invisible if no
match] when there is a match and then take them to that specific record in
another form.
Finally, I don't want the button to be displayed until they have selected
which type of utility it is [cboUtilityType].
Hope thats clear.
tia