Access Query with System Name

[talkvinith]

Hello all,


I want the records to be pulled on the form for those which are blank in the status and based on the system name(. i.e if i click on the comment button on the form the status blank only get into the form and this is based on the system name.

Can someone please help me in this.

[AliGW]

What is your question? If this thread is not needed, I will delete it.

[talkvinith]

Hello all,

I am a newbie to the access.

I want the records to be pulled on the form for those which are blank in the status and based on the system name(. i.e if i click on the comment button on the form the status blank only get into the form and this is based on the system name.

Can someone please help me in this.

[alansidman]

Bind your form to a query. Not enough information provided to give you a more detailed response.

[talkvinith]

Thank you for your response.

I want the user to get the records on the form based on the system name provided. In the table data the system name will be given and when the user click the command button on the form the data with the respective system name should only pulled on to the form.
Eg: If the system name is SS45 that record only be shown to that user and the user update the record with the required information the next record should be pulled when clicking on the command button.

[talkvinith]

Hi

I have uploaded a sample file.

[talkvinith]

Can anyone pls help me in this?

[alansidman]

You have no field in your table named "System Name" nor any control on your form with that name. Which field/control do you wish to search on? If it is the "Verified ID", that field is not unique and search on it will return multiple records. Please be specific as to which field to search on?

If I am understanding your request correctly, then the video in the link below should satisfy your needs.

http://www.datapigtechnologies.com/f...tomfilter.html