Code behind form
after update event of the combo box or whatever other way that the user
selects whether it is a quote or not

Select Case Me.ctrInvoiceStatus
Case "Invoice"
Me.ctrTruckNumber.Visible = -1
Me.ctrTicketNumber.Visible = -1
Case "Quote"
Me.ctrTruckNumber.Visible = 0
Me.ctrTicketNumber.Visible = -1
End Select

This is the most straight forward - least fancy way

babs wrote:
Haven't heard back still need help see below:

Sound like not a bad idea. It is just that 2 different people will be
inputting the info and the quote person does not need to enter
truck#,ticket#, and some other fields in. HOw can I handle this that the
quote person doesn't see those fields but the invoice person does??????

Thanks,
Barb

"David C. Holley" wrote:

So why not just add a field named txtStatus or txtType and use that to
indicate if its a QUOTE or INVOICE?
[quoted text clipped - 40 lines]
Please help thanks,
Barb

Was this post helpful to you?

Why should I rate a post?





--
Message posted via http://www.accessmonster.com