sub form as form view not datasheet (1 Viewer)

theDBguy said:

Hi. Create a fresh copy and try to post it again, so we can take another look.

Click to expand...

lizcliff said:

Hi
I have started from scratch
only creating the referral form, and attempted sub form so they are related but I still cannot get the referral ID to equal the ID in referrals. (ignore all formatting I really haven't bothered with it until the joins are sussed)

the idea is from a home screen (yet to set up) you are able to log a referral using referral form, then again from home screen click therapy form add a therapy to exciting referral (but hospital numbers could have multiple referrals so the person entering data needs to search for hospital number and referral date to pick up the correct referral)

I think maybe this is why there is a disconnect on my forms that I'm not getting?

I have many more forms to set up based on this method too
thanks! for your help

https://www.dropbox.com/s/zqgdejvpf77vm3w/sstest.accdb?dl=0

Click to expand...

theDBguy said:

Hi. See if this helps...

Click to expand...

lizcliff said:

I think this has worked!!! thank you
how? ...

Click to expand...

theDBguy said:

Hi. You're welcome. If I understood it correctly, you wanted to use the dropdown at the top to "search" for a specific record on your form. Unfortunately, this is not what was happening. So, what I did was fixed the code and made the dropdown unbound.

Click to expand...

lizcliff said:

thanks I think I have found it - that's the event after update? on the combo box

Click to expand...