Change fields based on a combobox click

[Richie27]

Hi all,



I have a form with two main fields.

These fields are used to store dates for the purposes of identifying the time frame of all the records that are in a box.

However, in a small few circumstances I need to be able to store PIN numbers to identify records that are in a box.

So, basically I need a form that will only show two fields based on what is clicked in a combobox.

In other words, instead of having four fields - 2 for date and two for numbers (both are mutually exclusive and aren't required on the form at the same time) or creating another form for the rare instances where I need to store numbers instead of dates - I would like the fields to change from date fields to number fields when a certain item in the combobox is clicked.

So let's say I have dozens of categories like payroll, correspondence, claims, invoices, etc ----when I click invoices I want the default date fields to change to number fields instead.

Is that clear as muddy water?

Thanks in advance my mentors!

[June7]

Can use VBA code to change the ControlSource property of the boxes when the form opens or use the Current event so that will change if navigating between records. And maybe the Change event of checkbox.

[Richie27]

I must be learning because a couple of months ago I wouldn't have had the foggiest what you were talking about!

Is it possible to do something similar for the label as well?

Thanks.

[ssanfu]

Of course. You just have to change the label caption property.

[Richie27]

I tried this but it didn't work. Need help before my eyes pop out of my head! ;-)

Private Sub cboDesc_Change()

If (cboDesc.Value = 5) Then

[Forms]![frmFN_FilesBox]![frmFN_Box subform].Form.date_number.ControlSource = "fileStartNo"

End If

End Sub

It keeps saying "the value you entered isn't valid for this field." Could it be related to changing the control source of a date field to a number field or am I just clutching at straws?

Cheers Amigos!

[Richie27]

S'okay. tis fixed. I just had to put in the .ControlSource bit above. Doh.

It's always the little things.

Three o'clock slump methinks!

Thanks guys!