Update records

[herby_one]

Hi,
I have a basic 'landlord details' table which includes a 'landlord_type' field. Landlords must be either 'private' or 'business'.
I have a form with two subforms - one each for private and business.
When I select the 'Save' button, I want the landlord_type field to be updated in the table, ie. if the Save button in the Private subform is hit then Private displayed in the table and same for business.
I've tried the OnClick event but without success.
I know this should be some basic VBA but any suggestions would be appreciated.
thanks in advance.

 

[ted.martin]

Combo Box

Why not use a combo box rather than a Sub Form?

 

[Bat17]

have the 'landlord_type' field on the main form and set the value with the save button before actualy saving, then it will save with the record set

Peter

 

[herby_one]

Combo Box

thanks for the quick reply!
yeah I did consider that....
When I select a landlord type in the combo box, can certain fields then be made inactive. For example I have several fields that data will only be entered if the type is 'business'.
Is it best to do this through VBA or is there an easier way?
thanks again.