H
halfbodyguy
Ok, I am making a check in / check out database to log who has specific
tools (lumber field)
I have a form tied to each user, which has multiple instances of a
subform that allows you to check out each tool (Drop down list of
tools, select 1 per instance)
Basically, the subform query tells the form to populate the dropdown
with only the tools that are NOT checked out, That works great, except
that When i append the selections, each instance of the subform updates
correctly, limiting the selection to ONLY the tools that are not
checked out, EXCEPT the instances that i used to select last time.
For example, I pick 3 tools to check out, with Instance 1,2,3.
I append (basically a update and requery, so that it can appear in a
list on the form), All the instances have those 3 tools removed from
their drob-down, EXCEPT the ones i used to select those 3 are now
locked as they were right when I used them, until i go to design view
and back, then they are correct... Any ideas? or what code / info would
be helpful to get this figured out?
tools (lumber field)
I have a form tied to each user, which has multiple instances of a
subform that allows you to check out each tool (Drop down list of
tools, select 1 per instance)
Basically, the subform query tells the form to populate the dropdown
with only the tools that are NOT checked out, That works great, except
that When i append the selections, each instance of the subform updates
correctly, limiting the selection to ONLY the tools that are not
checked out, EXCEPT the instances that i used to select last time.
For example, I pick 3 tools to check out, with Instance 1,2,3.
I append (basically a update and requery, so that it can appear in a
list on the form), All the instances have those 3 tools removed from
their drob-down, EXCEPT the ones i used to select those 3 are now
locked as they were right when I used them, until i go to design view
and back, then they are correct... Any ideas? or what code / info would
be helpful to get this figured out?