lock cell in subform unless cell in form has data in it

[holden_1]

Hi,

is it possible to lock (or otherwise prevent user from entering data into) a cell on a subform untill a particular cell in the parent form has data entered into it?

thanks for any help.

Rob

 

[Rabbie]

Do you mean Fields? Access doesn't have Cells. If you base your form/subform on a query using linked tables then this should work correctly. Look at th Orders form in the Northwind sample DB supplied with Access to see how it is done.

 

[holden_1]

yes, fields...
think i've found a way around this...

[Private Sub Part_Number_AfterUpdate()
Me![sfrm_raise].Enabled = True
End Sub

Private Sub Form_Current()
DoCmd.Maximize
Me![sfrm_raise].Enabled = False
End Sub]

i forgot you could manipulate the properties of fields thru vb. bit rusty on this stuff, first db i've done in 4yrs!

 

[holden_1]

or not...

.visible =

worked, but not enabled... how odd!

 

[holden_1]

oh, wait, done something daft... subform was set to visible = no as default... durr.

you can really tie yourself in knots with this stuff!

thanks anyway, i guess it just took a little thought. basically trying to make the whole thing idiot proof!