Access tables

[alfiwalf]

Hi,

I am new here so I hope this is the correct place to post this. I have two tables and two forms; each form is created from its corresponding table. I have one form that allows a user to input details about an individual piece of property (details stored in relevant table); the second form is selected from the first and allows a user to track the movements of the item in the first.

I have a primary key in the first and a field in the second table that relates to that primary key.

What I want to do is when a user enters the detail of an item in the first form and selects the second form to track its movements I want two fields in the second form to be automatically populated from the corresponding fields in the first.

 

[jdraw]

I recommend you write a 4-5 line description of WHAT your "business" is and "things" are involved in simple English. Get your tables identified and designed to match the "things" in your business. Here is a link to a a tutorial on Normalization. I suggest you get your tables designed and tested with some sample data to make sure your design matches your needs. Then, move to forms....

Good luck with your project.

 

[pbaldy]

This if it's appropriate:

http://www.baldyweb.com/wherecondition.htm

or:

DoCmd.OpenForm "NewFormName"...
Forms!NewFormName.TextboxName = Me.textboxName

 

[alfiwalf]

Gents, my apologies if I did not make what I would like to do clear.

To recap - I have a table (PropertyReceived_T) with 20 fields in it that store information about an item of property; amongst these are the following 'FieldNames':

PropertyEntryNumber (Primary Key);
Property_Description.

I have created a form (PropertyReceived_F) using the 'FieldNames' in the table to allow a user to create entries as different items of property are received and also to display the property entries that may already exist.

For reasons of security when each item is taken out of storage the details must be recorded; likewise when it is replaced back into storage the details must also be recorded.

I have created a second table to record the movement details (PropertyMovement_T), in this table I have a 'PropertyMovementNo' field which is the primary key. I have also created the following fields:

PropertyEntryNo;
Property_Description.

On the form 'PropertyReceived_F' I have created a button that when clicked takes you to the form 'PropertyMovement_F'; what I would like to do is carry the information 'PropertyEntryNo' and 'Property_Description' from the form 'PropertyReceived_F' and display it in the appropriate fields on the form 'PropertyMovement_F' when it is opened.

I have looked at the responses which I thank you for but still do not understand how to do it; where does the code go please?

In essence I have an item in the 'PropertyReceived_T' that could have many entries in the 'PropertyMovement_T'; I hope that creating a 'one to many' relationship between the field 'PropertyEntryNo' in both tables it should keep the relationship correct.

I apologise if I am being really dumb here.

 

[pbaldy]

The code would go behind the button:

http://www.baldyweb.com/FirstVBA.htm

If you were unaware, you could also use a form/subform, which is a common way to present a one to many relationship.

 

[alfiwalf]

Pbaldy,

Many thanks for your assistance; I have managed to achieve what I needed.

Regards,

Alfiwalf

 

[pbaldy]

Happy to help!