A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form and subform for partial data entry



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2010, 05:02 PM posted to microsoft.public.access.forms
Drizztdj
external usenet poster
 
Posts: 1
Default Form and subform for partial data entry

While I use Access often, I'm not much of a programmer but can read most of
it.

My question is I am trying to build a form which pulls information from two
different places:

ContactTable
GroupTable

All of the information from the ContactTable is found within the GroupTable.
My objective is to have the user open the form and see the contact
information in a subform triggered from a vendor number, but not be able to
change that information while being able to create a new record from other
fields.

Also, if the vendor number has not been used before, or no contact
information is available unlock the subform so the user can enter address
information.

Wish I could explain this better.
  #2  
Old April 28th, 2010, 11:00 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Form and subform for partial data entry

Where you wrote:
"All of the information from the ContactTable is found within the
GroupTable",

This will make things more difficult.
If you set up your tables so that the Group table has only the Primary key
from the Contact table, this allows easy set up of main form and subform.
Also you mention vendor number.

If you post back with a more complete description of what you are trying to
do, we will be able to suggest a workable table setup.
Once the tables are set up correctly, it will be much easier to build the
forms and subforms.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"Drizztdj" wrote in message
...
While I use Access often, I'm not much of a programmer but can read most
of
it.

My question is I am trying to build a form which pulls information from
two
different places:

ContactTable
GroupTable

All of the information from the ContactTable is found within the
GroupTable.
My objective is to have the user open the form and see the contact
information in a subform triggered from a vendor number, but not be able
to
change that information while being able to create a new record from other
fields.

Also, if the vendor number has not been used before, or no contact
information is available unlock the subform so the user can enter address
information.

Wish I could explain this better.



  #3  
Old April 29th, 2010, 01:36 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Form and subform for partial data entry

On Wed, 28 Apr 2010 09:02:01 -0700, Drizztdj
wrote:

While I use Access often, I'm not much of a programmer but can read most of
it.

My question is I am trying to build a form which pulls information from two
different places:

ContactTable
GroupTable

All of the information from the ContactTable is found within the GroupTable.


Eh?

That would imply that you're storing the same data redundantly in two
different tables, and that the ContactTable should probably simply not exist!

Am I misinterpreting that sentence?

My objective is to have the user open the form and see the contact
information in a subform triggered from a vendor number, but not be able to
change that information while being able to create a new record from other
fields.


Again: create a new record from other fields sounds redundant, and *wrong*.

Also, if the vendor number has not been used before, or no contact
information is available unlock the subform so the user can enter address
information.

Wish I could explain this better.


It would certainly help if you did. What are the fields (or some relevant
fields) of the two tables? What (if anything) is the Primary Key of each
table? what (if any) is the Relationship between the two tables? What
real-life Entity (person, thing, event) does each table model?
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.