allow data entry based on category field

[atledreier]

Hello!

I have a database with tblTag, tblTag_Format_IN and tblTag_Format_FG

tblTag have a field 'tag category', that define the type, and
subsequently the category table to be filled.

My users prefer datasheet view of tblTag, and the tblTag_Format_IN and
tblTag_Format_FG data in the same datasheet. I have this set up now,
and it works fine, as long as my users are disciplined and only fill
the correct fields. If they accidentally fill enter data in the wrong
fields unessesary records are created.
Is there any way to inhibit data entry based on the category field?

- Atle

 

[pietlinden]

Hello!

I have a database with tblTag, tblTag_Format_IN and tblTag_Format_FG

tblTag have a field 'tag category', that define the type, and
subsequently the category table to be filled.

My users prefer datasheet view of tblTag, and the tblTag_Format_IN and
tblTag_Format_FG data in the same datasheet. I have this set up now,
and it works fine, as long as my users are disciplined and only fill
the correct fields. If they accidentally fill enter data in the wrong
fields unessesary records are created.
Is there any way to inhibit data entry based on the category field?

- Atle

in datasheet view, no. If you use continuous forms, you can enable/
disable controls based on the value of other controls in the OnExit/
AfterUpdate events of the controls.

 

[atledreier]

in datasheet view, no.  If you use continuous forms, you can enable/
disable controls based on the value of other controls in the OnExit/
AfterUpdate events of the controls.

So you're saying I should make a continuous form that LOOKS like a
datasheet (or as close as I can get), and make it behave like I want
programmatically?