show table on form?

kingzl3y

Registered User.
Local time
Today, 18:24
Joined
Mar 20, 2008
Messages
20
Hoi!
Basically, I've got a form:
LOAN.jpg
And as you can see, in order to select the right loan (Or even see the loan details, Nursery name, book name, author etc) you have to look in to the loan table and then remember the Loan_ID
GO back into the delete loan table and select the right loan_ID from the combo box...
most people will probably forget before they even get to the delete_loan form :')

So, somehow i'd like to insert some kind of 'sub' table at the bottom of my form..
which will list all the loans from the loan table..
I've tried sub report/sub form.. but it kept updating every time i chose a record in the combobox..(Lets say i selected #5 in my combobox, the table would then only show #5)
I don't want to do anything with it, just show the current loans

Is there any way to do this?
Cheeeeeeèrs!
 
Last edited:
You can bring in more information (fields) with your combo box, and you can display something other than the ID # if you want. The ID # will still be the bound field, but you can adjust the column width to 0 by going to properties of the combo box and looking at column widths under the format tab. You can then increase the column width of the field you want the user to see when they select an item in the combo box.

Alternatively, you can also display information from the combo box in unbound textbox controls on your form.

I've attached a DB as an example
 

Attachments

Hmmmm yeah!
I suppose that's another way of doing it!
But, with me it's alot more complicated..
In my loan table I only have:

LOAN_ID
BOOK_ID
NURSERY_ID
LOAN_DATE
BOOK_RETURNED

And if one wants to delete a loan they must first either Look up the loan ID on the table and then search for the Book_ID until they find the right one they want to delete or Read the invoice which was printed on the date of the loan.

I've kinda got it working..
LOAN_TABLE.jpg

But, as you can see..i currently have 2 loans in the combo box...
but the Subform is only showing the one which is selected in my Combobox.
I just want it to show all the records.. and not filter it's self with whatever i have in my combobox..
If that makes sense :' )
I've got a query for the loan table..which i want to show in the subform

Any ideas?

Cheers!
 
Is the main form bound to a table or is it unbound? What is the query for the subform and is it tied to the combo box in any way? Also, Access will try to link the main and subforms using a primary/foreign key relationship. You can override this by going into the data properties of the subform and removing the field names in the Link Master Fields and Link Child Fields sections
 
Last edited:

Users who are viewing this thread

Back
Top Bottom