[AccessD] Related combos in a datasheet

Are we talking continuous form or datasheet here?  In a continuous form
you can use a textbox bound to the same field to display the actual
contents of the field, even when the combobox doesn't contain a match.
Not possible in a datasheet, as far as I know.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, September 04, 2007 8:15 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Related combos in a datasheet

Arthur, I don't think you can -- it kind of goes against the form's
nature.
I've worked with this problem off in on in one of my own apps -- where I
want to disable a control based on the contents of another -- but I've
never gotten it to work in continuous form. 

Susan H. 

Has anyone figured out how to make related combos work in a datasheet
form?
They work fine in a single form, but in a datasheet they have a problem,
in that redefining the second combo's row source screws up the display
of the other visible records.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com