[computerman29642]

I have added 4 new forms (frmMNumberSearch, frmTitleSearch, frmSearch, and a Switchboard). I am unsure if I want to continue using the tabbed form, or start using the switchboard.

Please review the attached database, and let me know what you all think I should do.

[OBP]

I haven't looked at it yet, but on principle I prefer the Switchboard for "Admin" stuff, ie background data and the Tabbed mainform for all things "Movie".

[computerman29642]

I was not really sure how to use the new search forms with the tabbed main form. Maybe the search forms were a wasted effort (not really needed).

[OBP]

They are a good exercise, even you don't use them much.
See my latest posts on Mark's thread on how to create a "Multi-Search" form instead of 4 seperate forms.
http://forums.techguy.org/business-a...hed-db-10.html

[computerman29642]

It appears that you have subform on top of subform. Is that correct?

[OBP]

Yep, neat isn't it?

[computerman29642]

Very neat. The problem is.....will I be able to reproduce it...LOL!

[computerman29642]

How can I take the frmCheckOut/In form add a combo box that displays the customers, and then CheckOut/In infrmation only for that customer.

[Aj_old]

Originally Posted by gamecockfan

How can I take the frmCheckOut/In form add a combo box that displays the customers, and then CheckOut/In infrmation only for that customer.

Make a new form base on the tblCustomers, put there all 3 field of the table, arange them on newly created form, after that add subform frmCheckOut/In

[OBP]

I am not sure that you can do it with your current Form as it is linked to the MovieID, I think you would have to employ the Multi search Concept and have another (hidden) form on the Tab that is filtered by the customer combo and only made visible when the Combo is clicked. You could develop the Query and Form and then add it to the Tab after you have it working.

[computerman29642]

Okay. I am going to start working on the Multi Search Form.

[computerman29642]

Should I have a switchboard or just have the tab form open?

[OBP]

I would have both, but have the one used most as the one opened on top when the database opens.

[computerman29642]

When a new movie is added, how do I set the default availability to available?

[OBP]

Me.Availability = "Available"
in the After Update event of the Movie title field