Auto populate fields in new form

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

HI,

I have inherited a database in access 2000 - the primary function is to
record customers, the contact and the subsequent orders.

I have 3 tables (customer, contacts and orders) each linked with one to many
relationships with the order table linked to both customers and contacts.

What I would like to happen is the following:
customer entry is chosen followed by the contact, I then need to open and
order form which is already linked to the customer and contact without any
additional entries.

All the forms currently work in that I can open the order form and view all
previous orders just can not enter new ones and keep them linked to the
customer and contact.

Please note that I am a VBA novice.

Many thanks

Charlotte
 
Charlotte

I'm having trouble visualizing your situation...

Are you saying that your "orders" don't have any "details" (e.g., more than
one "item" ordered at a time)?

I can see that a [Customer] could have one-to-many [Contacts], and that a
[Customer] could have one-to-many [Orders], but a common scenario in
customer orders is that they order more than one thing.

More info, please...

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Hi Jeff,

The orders are filled in as required, however the entered details appear on
the table but not the customer or contact details unless these are entered
manually - I want to go from the customer form into the order form and have
the customer details already inserted.

I've seen this work in an access database before but am not in a position to
ask the designer how it works.

Charlotte

Jeff Boyce said:
Charlotte

I'm having trouble visualizing your situation...

Are you saying that your "orders" don't have any "details" (e.g., more than
one "item" ordered at a time)?

I can see that a [Customer] could have one-to-many [Contacts], and that a
[Customer] could have one-to-many [Orders], but a common scenario in
customer orders is that they order more than one thing.

More info, please...

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Charlie said:
HI,

I have inherited a database in access 2000 - the primary function is to
record customers, the contact and the subsequent orders.

I have 3 tables (customer, contacts and orders) each linked with one to
many
relationships with the order table linked to both customers and contacts.

What I would like to happen is the following:
customer entry is chosen followed by the contact, I then need to open and
order form which is already linked to the customer and contact without any
additional entries.

All the forms currently work in that I can open the order form and view
all
previous orders just can not enter new ones and keep them linked to the
customer and contact.

Please note that I am a VBA novice.

Many thanks

Charlotte
Click to expand...


.
Click to expand...
 
I'm still not clear on the real-world situation you are trying to model.

Can your "order" have more than one "item"?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Charlie said:
Hi Jeff,

The orders are filled in as required, however the entered details appear
on
the table but not the customer or contact details unless these are entered
manually - I want to go from the customer form into the order form and
have
the customer details already inserted.

I've seen this work in an access database before but am not in a position
to
ask the designer how it works.

Charlotte

Jeff Boyce said:
Charlotte

I'm having trouble visualizing your situation...

Are you saying that your "orders" don't have any "details" (e.g., more
than
one "item" ordered at a time)?

I can see that a [Customer] could have one-to-many [Contacts], and that a
[Customer] could have one-to-many [Orders], but a common scenario in
customer orders is that they order more than one thing.

More info, please...

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned
in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Charlie said:
HI,

I have inherited a database in access 2000 - the primary function is to
record customers, the contact and the subsequent orders.

I have 3 tables (customer, contacts and orders) each linked with one to
many
relationships with the order table linked to both customers and
contacts.

What I would like to happen is the following:
customer entry is chosen followed by the contact, I then need to open
and
order form which is already linked to the customer and contact without
any
additional entries.

All the forms currently work in that I can open the order form and view
all
previous orders just can not enter new ones and keep them linked to the
customer and contact.

Please note that I am a VBA novice.

Many thanks

Charlotte
Click to expand...


.
Click to expand...
Click to expand...
 
Hi Jeff,

The real world use is for an ordering system - the details entered into the
order will be unique to that order, however they need to be linked to the
customer and the relevent customer contact. I have used a database in the
past where the command on the relevent contact opened the Order form and
populated the company and contact details.

If I look and the tables I can see which contacts are linked to the
companies and again which orders are connected to the relevent contacts - i
just can't seem to get this to work without using subforms - unfortunately,
the visual are of each form are currently filling the screen and I am loathed
to extent this as I am sure things will be missed or filled in incorrectly.

I am open to any suggestions.

Many thanks

Charlotte

Jeff Boyce said:
I'm still not clear on the real-world situation you are trying to model.

Can your "order" have more than one "item"?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Charlie said:
Hi Jeff,

The orders are filled in as required, however the entered details appear
on
the table but not the customer or contact details unless these are entered
manually - I want to go from the customer form into the order form and
have
the customer details already inserted.

I've seen this work in an access database before but am not in a position
to
ask the designer how it works.

Charlotte

Jeff Boyce said:
Charlotte

I'm having trouble visualizing your situation...

Are you saying that your "orders" don't have any "details" (e.g., more
than
one "item" ordered at a time)?

I can see that a [Customer] could have one-to-many [Contacts], and that a
[Customer] could have one-to-many [Orders], but a common scenario in
customer orders is that they order more than one thing.

More info, please...

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned
in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

HI,

I have inherited a database in access 2000 - the primary function is to
record customers, the contact and the subsequent orders.

I have 3 tables (customer, contacts and orders) each linked with one to
many
relationships with the order table linked to both customers and
contacts.

What I would like to happen is the following:
customer entry is chosen followed by the contact, I then need to open
and
order form which is already linked to the customer and contact without
any
additional entries.

All the forms currently work in that I can open the order form and view
all
previous orders just can not enter new ones and keep them linked to the
customer and contact.

Please note that I am a VBA novice.

Many thanks

Charlotte


.
Click to expand...
Click to expand...


.
Click to expand...
 
Charlotte

The Northwind application comes free with Access. It offers an example of
an "order" system. Is there anything in that example you can use?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Charlie said:
Hi Jeff,

The real world use is for an ordering system - the details entered into
the
order will be unique to that order, however they need to be linked to the
customer and the relevent customer contact. I have used a database in the
past where the command on the relevent contact opened the Order form and
populated the company and contact details.

If I look and the tables I can see which contacts are linked to the
companies and again which orders are connected to the relevent contacts -
i
just can't seem to get this to work without using subforms -
unfortunately,
the visual are of each form are currently filling the screen and I am
loathed
to extent this as I am sure things will be missed or filled in
incorrectly.

I am open to any suggestions.

Many thanks

Charlotte

Jeff Boyce said:
I'm still not clear on the real-world situation you are trying to model.

Can your "order" have more than one "item"?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned
in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Charlie said:
Hi Jeff,

The orders are filled in as required, however the entered details
appear
on
the table but not the customer or contact details unless these are
entered
manually - I want to go from the customer form into the order form and
have
the customer details already inserted.

I've seen this work in an access database before but am not in a
position
to
ask the designer how it works.

Charlotte

:

Charlotte

I'm having trouble visualizing your situation...

Are you saying that your "orders" don't have any "details" (e.g., more
than
one "item" ordered at a time)?

I can see that a [Customer] could have one-to-many [Contacts], and
that a
[Customer] could have one-to-many [Orders], but a common scenario in
customer orders is that they order more than one thing.

More info, please...

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services
mentioned
in
this post. Mention and/or description of a product or service herein
does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with
no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

HI,

I have inherited a database in access 2000 - the primary function is
to
record customers, the contact and the subsequent orders.

I have 3 tables (customer, contacts and orders) each linked with one
to
many
relationships with the order table linked to both customers and
contacts.

What I would like to happen is the following:
customer entry is chosen followed by the contact, I then need to
open
and
order form which is already linked to the customer and contact
without
any
additional entries.

All the forms currently work in that I can open the order form and
view
all
previous orders just can not enter new ones and keep them linked to
the
customer and contact.

Please note that I am a VBA novice.

Many thanks

Charlotte


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top