Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Can't use Find function in subform

Discussion in 'Information Technology' started by Chris Burnette, Nov 18, 2005.

  1. Chris Burnette

    Chris Burnette
    Expand Collapse

    I currently have a form based on 4 tables. The main form is based on 1
    table, and I have a tab control with 3 subforms, each in their own tab. I am
    using the LinkMaster/LinkChild fields property to make sure that the IDs in
    all the forms match up, but that records are created in a particular table
    only if data is entered in the corresponding subform.

    While this all seems to work perfectly well, the major problem I am having
    now is that when I use the LinkMaster/LinkChild fields, I am no longer able
    to use the Find function to search for records in my subforms, as there is
    usually only 1 record that is linked.

    If I don't use LinkMaster/LinkChild fields, I am not sure how to make sure
    that the records in my tables are all properly linked (i.e. all have the same
    FK relationship). In addition, when I scroll through my main form it doesn't
    move to the corresponding record in my subform, and vice versa.

    So, my question is whether or not there is a way to use the Find function in
    a subform, and if not, then how should I change my form so that I can keep
    the records in the tables linked?

    I am a bit stumped on this one, so as always any help would be appreciated.


  2. Loading...

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page