Query results to display in a form

[sunbear629]

First, I am a beginner with Access. I am a graphics designer that has been assigned to cover for a db programmer that quit!

So, I have a basic 27 field, 675 row database, and would like to do a query on a single unique text field, and have the results display in a form.

If this is really basic, I appologize. I have 20 years experience with Photoshop, and 4 days experience with Access.

Thanks in advance for any assistance.

 

[RichO]

If I understand your question, you're looking to get the value from one single field of one single record and display it on your form?

If this is the case, you can use DLookup. Access help explains it pretty well and you can put the expression right into the control source of your textbox without having to use any VBA.

BTW, I'm in the process of learning PhotoShop. Are there any good forums out there?

 

[sunbear629]

Here is what I am trying to do.

On a form, there is a input text box for a login name. When the user type in the login name, and then hits something like a "submit" button, the entire record will display in a form (form is used for data presentation clarity).

As far as Photoshop tutorials and forum help is concerned, I would recommend Photoshopuser.com, and the WDVL.com tutorial pages. Like DB programming, Photoshop can be a bit intimidating, but it is a practice, practice, practice type of program.

 

[RichO]

So I have this straight, is the log-in name is present in the table and you just need to pull up the related record from the table?

 

[sunbear629]

I have two tables.

Table one (tblUserList): has complete user information INCLUDING the field LoginName. Other fields include StreetAddress, CityStateZip, PhoneNo1, PhoneNo2, etc.

Table two (tblPermissions): has the users system permissions. This table has 14 fields, leading of with LoginName, and 13 Yes/No fields.

I have one form (frmSysUsers), which currently displays all the data fields for the users.

Thus far I have managed to learned how to create up to the point I can add the data on the form, and I can look at the data in the form.

In all the books I am using as a reference, I just can't find a way to search for a particular record and display just it!