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

Link unbound form to bound form

P: 7
I have a database that in Table form it shows the subdatasheets that make refrence to the main table. It is basically a Menu ordering system. Goes something like this:
MenuByCycle (Contains: Cycle and year), MenuByDay (Contains: Day), MenuByDiet (Contains: TypeOfDiets), FoodItemsByMenu (The actual menu items)
That was my best attempt to normalize the database.
Like I said in the beginning, in Table subdatasheet form I can view the sub tables and add values. I am trying to port this to Forms.
I have made a form that filters (via Recordset) a subform to the FoodItemsByMenu table. I can view the subform (datasheet) by each type of filter, but I want to be able to link the foreign keys from the parent form so that I don't have to enter them repeatedly. The parent form is unbound since it is just to search by cycle, year, day and TypeOfDiet. This information filters the subform so it displays the FoodItemsByMenu table to view and input new records if necesarry.

I tried using the same query as record source for the main form as it really doesn't matter, since it says can't build a link between unbound forms, and didn't work.

Can I try a OpenArgs?
Sep 26 '08 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,661
I have to say I struggle to understand technically what you're doing (or more precisely how you're trying to do it).

However, using OpenArgs is almost certainly worth trying if you need to (I would focus principally on getting a filter to work).
Sep 26 '08 #2

Expert 2.5K+
P: 2,653
Hello, Papote.

Take a look at Add Matching Record on Filtered Form thread.

Sep 27 '08 #3

Post your reply

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