R
Raymond
Hey there,
This question is 2 part I guess and thanks in advance for all the help I
receive in here. It seriously is unparalleled.
I have a form (obviously) that has certain text fields:
UNIT 1
UNIT 2
UNIT 3
UNIT 4
On the form itself, I have a subform ran from a query that has 2 fields
(Unit Description "OSPO3400" and an Active Field. It states to only show the
units that are True. That way when they select their inventory, the unit(s)
will not be available the next record. I am using Access 2007. I tried a
simple macro where I did:
GotoControl [Form1 - Subform]
RunCommand [Copy]
GotoControl [Form1 - Subform]
RunCommand [Paste]
This works for the first Unit but every other unit after that I receive an
error telling me that the macro isn't available.
This would be the easiest way, so is there a way to enable all the macros?
I notice when I am creating a simple macro you have to select Show All
Macros. Or is there a way to have a combo box with that active field in
column(1) and after updated, check that box so it updates in the table?
Thanks again in advance,
Rainman
This question is 2 part I guess and thanks in advance for all the help I
receive in here. It seriously is unparalleled.
I have a form (obviously) that has certain text fields:
UNIT 1
UNIT 2
UNIT 3
UNIT 4
On the form itself, I have a subform ran from a query that has 2 fields
(Unit Description "OSPO3400" and an Active Field. It states to only show the
units that are True. That way when they select their inventory, the unit(s)
will not be available the next record. I am using Access 2007. I tried a
simple macro where I did:
GotoControl [Form1 - Subform]
RunCommand [Copy]
GotoControl [Form1 - Subform]
RunCommand [Paste]
This works for the first Unit but every other unit after that I receive an
error telling me that the macro isn't available.
This would be the easiest way, so is there a way to enable all the macros?
I notice when I am creating a simple macro you have to select Show All
Macros. Or is there a way to have a combo box with that active field in
column(1) and after updated, check that box so it updates in the table?
Thanks again in advance,
Rainman