Re: Auto populate a form from an open form

I would suppose you could do that, although I've never done that. The query behind the
pop up would use some value from the open main form to filter the records delivered.
Have you considered Tab pages for multiple subforms... if space on the main form is an
issue?
That's the "usual" method...
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

"far-mer" <u32423@uwe> wrote in message news:6f135b585d91d@xxxxxx
Al thanks

My understanding is that a sub-form would have to embedded into the main form?
I was hoping to find a solution that would enable the form to pop-up?

Thanks for your response

Chris

Al Campagna wrote:
Chris,
You should use a subform, related to the main form via some unique key field like
ClientID.
Your tblClients table (the ONE) related to tblCalls table (the MANY).
When a client calls, go to that client record and add another record to the Call
subform... (date, starttime, stoptime, subject... etc)
You don't want to save the Customer name and address in each call record... just
relate the calls to the Client via the ClientID.

Hi

[quoted text clipped - 9 lines]

Chris



.

Relevant Pages

  • Re: Huge database weighs heavily on small brain
    ... You probably need to read-up about the topic of database "normalization". ... > Regarding the combo boxes as subforms, ... For example, the Client Brand Drug ... > the Display Control, ...
    (microsoft.public.access.forms)
  • Re: Huge database weighs heavily on small brain
    ... rules of normalization in mind as I revise this database. ... Pharmacies, etc., however, my repeated replication of the entire database ... >> Regarding the combo boxes as subforms, ... For example, the Client Brand Drug ...
    (microsoft.public.access.forms)
  • Re: Huge database weighs heavily on small brain
    ... separate tables for the current and each review period. ... Regarding the combo boxes as subforms, ... For example, the Client Brand Drug ... the Display Control, ...
    (microsoft.public.access.forms)
  • Re: Huge database weighs heavily on small brain
    ... Eligibility, Healthcare and PharmacyInterview). ... the Client). ... The Relationships between the the Main Form and the Subforms ... review forms are identical in design to the Main Form, ...
    (microsoft.public.access.forms)
  • Re: Reverse Form/SubForm Parent/Child relationship
    ... Mainform with a ComboBox or ListBox for the user to select a particular ... When a Client is selected, the Client becomes the Current Record on ... Note that linked Subforms are designed for Tables in One-to-Many ... Invoice and Service details, I want to be able to quickly scan the client ...
    (microsoft.public.access.forms)
Loading