How to Link the Form with Table

[littleheart_Sony]

Could some one help me in building the Forms and also to link up to a Table.



I have created a database, which has input data of clients.

Also i have created a Form with Clients1. As soon as i enter the Document number in form, it should display the related details to this documents in form.

Thanks in Advance.

[June7]

Set the form's RecordSource property. Set each control's ControlSource property. Those are very basic Access functionality.

If you want to build a search functionality into the form, for one method review: http://www.datapigtechnologies.com/f...tomfilter.html

You will need code behind the New Record button to move to a new record row. If you want to use macros, let the macro wizard build code for you. If the wizard is enabled, it should activate when you create button on form. It appears the macro wizard is not enabled in your db. Can enable by clicking the dropdown arrow with the line above it that is located on the Control section of the ribbon Design tab and then clicking "Use Control Wizards".

https://support.office.com/en-US/Art...rs=en-US&ad=US

[littleheart_Sony]

how to match two tables

could some one help me to match the two tables.

One table name is with masterdoc and NameDoc in these tables titledocid is common need to match

below is the attached access file for your reference

[June7]

Try:

Query1
SELECT masterdoc.*, Right([titledocid],3) AS NewDocID FROM masterdoc;

Query2
SELECT NameDoc.*, Query1.* FROM NameDoc LEFT JOIN Query1 ON NameDoc.titledocid = Query1.NewDocID;

[littleheart_Sony]

thanks for the help, i tried it but it is not giving me the exact result, could u please provide me a access file with this formula for reference. it will be very helpful to me

thanks in advance

[June7]

What good what it do to provide file? Those are just queries. If the queries don't give you want you want then giving you a file won't help.

What result do you want? You are going to have to be very specific. I did the best I could by analyzing the tables you provided. The queries I suggested made sense from what I could comprehend of the data structure.