By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

How to create Check In Form for a list of item in Access

P: 1
I'm creating an access database as my tools loaning system.

I'd create a tools table contain:
ToolingID
Description
Location
This table is mainly used as my tooling list database

Transaction table contain:
TransactionID
ToolingID
Checked Out by
Checked Out date
Checked Out to
Checked In by
Checked In date
Checked In to
This table is mainly used as transaction history include checked out but not checked in yet

Current Transaction Query contain tools that had been checked out but not checked in yet

I'd create a Checked In Form contain toolingID, Checked In by, Checked In date and Checked In to.

My problem is how can the ToolingID to be appear in this form provided that my RecordSource is Transaction table but not Current Transaction Query?

Do anyone have any thought on this?
1 Week Ago #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,419
I guess the first, and most obvious question is :
Why does your Form have to be based on the Transaction Table and not the Current Transaction Query?

Other than that of course, Forms can be filtered and sorted too. I see no problem with anything you've explained - except why you're asking for help. It isn't clear what your problem is.
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.