B
BenD
Hello,
I'm very new to Access, so I apologize if this question has been answered
before, but I am having trouble with the button function wizard.
I am creating an inventory database that creates a history of who has
checked out what equipment in the past, plus what equipment is currently
checked out. I have one Checkout/Checkin form based on an inventory history
table that creates a new record whenever someone checks out an item (the
table includes Equipment Number, Employee ID, Date Out and Date Returned).
The form has Equip Number, Employee ID and Date Out fields. I then have a
query to display equipment that is currently checked out (Date Returned = Is
Null).
On my Checkout/Checkin form I have two buttons: Checkout and Checkin. The
Checkout button creates a new record and works fine. According to the button
wizard, I set the Checkin button to open the Checkin form and search for a
record. I set the Equip Number fields in both forms to be related, so I was
under the impression that upon entering an Equip Number into the
Checkout/Checkin form and pressing "Checkin," the Checkin form should open
and display the associated record from the query. After this the user should
be able to enter the date returned, and hit "Return Equip" which saves the
record and closes the form. Instead, the form simply displays the first
record in the query. Not very helpful.
So am I misunderstanding the purpose of this button, or am I simply doing
something wrong? Any help would be greatly appreciated.
Thanks,
BenD
I'm very new to Access, so I apologize if this question has been answered
before, but I am having trouble with the button function wizard.
I am creating an inventory database that creates a history of who has
checked out what equipment in the past, plus what equipment is currently
checked out. I have one Checkout/Checkin form based on an inventory history
table that creates a new record whenever someone checks out an item (the
table includes Equipment Number, Employee ID, Date Out and Date Returned).
The form has Equip Number, Employee ID and Date Out fields. I then have a
query to display equipment that is currently checked out (Date Returned = Is
Null).
On my Checkout/Checkin form I have two buttons: Checkout and Checkin. The
Checkout button creates a new record and works fine. According to the button
wizard, I set the Checkin button to open the Checkin form and search for a
record. I set the Equip Number fields in both forms to be related, so I was
under the impression that upon entering an Equip Number into the
Checkout/Checkin form and pressing "Checkin," the Checkin form should open
and display the associated record from the query. After this the user should
be able to enter the date returned, and hit "Return Equip" which saves the
record and closes the form. Instead, the form simply displays the first
record in the query. Not very helpful.
So am I misunderstanding the purpose of this button, or am I simply doing
something wrong? Any help would be greatly appreciated.
Thanks,
BenD