Form Update from Table

[bahalzamon]

First off sorry if this is posted somewhere else, I could not find it. =)

I have a form with some fields as well as a table.
I would like to use the table within the form that I have set to not allow edits to select something within the table and the form fields update from the selected record.



I am fine with having either bound or unbound fields as I know how to update them, I just need to know how to basically select the specific record so I can update the form.
Also possibly a way to select only 1 record at a time would be nice but not mandatory as I am sure Access would just recognize the top most record.

I can attach images if you like, but I basically created it by clicking on the table and then form, so currently it is bound with some small modifications, but I plan on unbinding it and adding some error checking and auto-complete functionality.

[ItsMe]

You can open a bound form with its Data Entry property = to Yes and the User will not see any existing records in the table. In this mode, the user will only have access to the newly created records.

You can open a bound form to display records for viewing and not allow any edits by adjusting the form's Allow Edits property to = No.

You can open a form and adjust its Filter property to include Criteria so only certain records are displayed.

[bahalzamon]

@ItsMe,
Thanks for the quick response, but your resolution does either not match what I am asking or I am misunderstanding it and need some additional explanation.
I have just taught myself Access and VBA last week, so sorry for my slowness. =P

I have covered over some of the info, but what I would like to do is select something within the table (bottom) and then have the text boxes at the text boxes update depending on the selected student in the table.
The red box is where I plan to add some buttons for locking and unlocking the table and text boxes along with some additional information.
Basically I THINK I need to somehow have a record-set be created base on what I select in the table, then I can do a Me.SSID = R![firstName] and so on.
I would assume that I would need to set the table to a onClick event setting for the appropriate macro to run, but again, I am just starting to learn so any guidance preferably dumbed down would definitely help. =D

[June7]

Sounds like you want to do the third option ItsMe listed. Can use the intrinsic search/filter tools to find specific record or build your own search/filter utility. Review http://www.allenbrowne.com/ser-62.html

[bahalzamon]

@June7
Thanks for the response, I will check out the link and attempt to understand it and implement it.
I will reply with my results. =)
-Bahalzamon

Update:
I skimmed through your link and it is almost doing the opposite of what I am attempting to do.
The Text boxes are NOT search fields, they are for pure information and for the purpose of the current issue un-editable, just representation of the data.
I am wanting the fields to update based off of what I select within the table view.
I have attached another image, if what I am asking is still within that provided link I will continue to read it more in depth and see if I can get anything out of it.

[ItsMe]

I use forms as Graphical Interfaces. Using a Table or a Query Object as an interface for a user is not going to be of any benefit. At least, it won't be of any benefit in the long term. For instance, consider the problem you are struggling with right now. You need to trigger an event by selecting fields from within a table. In general, tables do not trigger events. In Access, it is best to use forms and controls within forms to drive the application.

[June7]

As ItsMe stated, users should not interact directly with tables and queries, only forms and reports. Tables and queries cannot have code (except for Data Macros behind tables and they won't do what you are looking for, assuming I understand what you want).

The link I referenced demonstrates use of unbound controls for user input of filter criteria. The inputs are used to find existing record.

A form can be designed to look like table and code behind form can then do what you describe - click record and open another form filtered to some value in the first form record. However, based on the image, perhaps a Split form will meet your needs.

[bahalzamon]

Is there any specific words to search for and/or links you would be able to provide for me to search for and learn from to attempt putting this into place?
Again thanks for the help. =)
-Bahalzamon

Edit:
Holy Cow, I cant believe it was something so simple. What I needed was the split form, thank you so much for the help and my ignorance. =)
I will mark as solved, thank you @June7 and @ ItsMe

[bahalzamon]

Update,

I was searching for something else and it brought me back to this forum and I found exactly what I was wanting without the ability of the user to edit the table.
It was using a list box rather than a table view. =)
https://www.accessforums.net/forms/s...lem-34319.html

[June7]

Form can be set to prevent user edits.

[bahalzamon]

Yep, I have that implemented already with Me.boxName.Locked = True and I even added some color to the boxes to denote whether they are locked and unlocked.
I currently unbound the boxes and am attempting to add some VBA to update it and provide some error checking for the users to do modifications.