Use a form to VIEW but not CHANGE

[ZLHysong]

Hi again,

I posted a question a few minutes ago, but I am suddenly having a different problem. (In addition to the other one)

I have several Forms that contain a ComboBox and several TextBoxes.

The ComboBox is linked to the Product Name column of the corresponding Table and, in turn, the TextBoxes pull relevant info based on the ComboBox Selection.



However, in selecting an Item using the ComboBox, the first item on the corresponding Table changes to a number and the rest of the cells in that row change to a different value, as if i am telling it to copy all the data from row 5 to row 1.

All I am trying to do is View the data from the Table, not edit it.

[alansidman]

Look at this tutorial:

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

[ZLHysong]

I just finished it, but I did not see anything at all that had to do with keeping the table Protected. Could you explain it to me please?

[alansidman]

It was simply a means to filter your table and bring the correct record up in the form. This is what it appeared you wish to do based upon your explantion in the original thread. Perhaps you would be better served creating a search form and having your results return in another form that has as its record source the query. In the properties of the new form, make it not editable or updateable.

[ZLHysong]

I'm lost. I'm sorry. I currently have this form:

When I select an item from the ComboBox, It fills the TextBoxes based on that selection. The issue is that it also Modifies the Table for no apparent reason, if I select something, the go to the "Size" TextBox, input information, and press enter, nothing happens. But for some reason, when I select different items with the ComboBox and then look at the Table, The first entry will be modified.

[alansidman]

This is because your form is bound to the table. This is what is supposed to happen. If you want to only look up data, then add a combo box to your header in your form and follow the instructions in the video, step by step to look up the particular record you want to see. The combo box you have is a lookup to populate the table. You need another one in your header to be used as a filter to find a particular record following the instructions in the video.

[ZLHysong]

Then what is happening that causes the change? If you read my steps above, I cannot willingly change the table, but some unknown step causes the change.

Also, would me setting the Record Locks to All Records Prevent the change?

[alansidman]

Suggest you upload your db so that we can demo the proper way to do this. Have you tried my solution in thread#6? You need an unbound control on your form to do the filter. I don't know how many more ways I can say this. You will need a separate combo box other than the one you currently are employing.

[ZLHysong]

I cannot upload the DB as it is too large, however, I am not disputing what you are saying, and I get how to do it now, I just do not understand why what is happening is happening, all you have done is repeat yourself several times with no explanation as to why my issue is occurring, which is my question.

I will ask the question again so there is no confusion:

When I select an item from the ComboBox I currently have, it changes item one in my Table. WHY?

[alansidman]

Unless I see your db, I cannot answer specifically. Your combo box is bound to the table. Any change in the combo box will result in a change in the table. If you still wish to share your db.
1. Include only a sampling of your data
2. Run a compact and repair
3. Dummy up any confidential information
4. Zip the file.
5. Upload

[ZLHysong]

Here is the DB. http://www.mediafire.com/?jrbnavym7xji8es

[alansidman]

I have examined your db. I don't see where you have set up a customized filter as we have been discussing. You have a combo box that allows you to make a selection for data input. A couple of questions that will help to understand how you are using this db.

1. Are you using the forms to enter new data into your tables?
2. Are forms used only for lookup of data and the tables will remain static?

Give me a general business sense how you will be using this db.

Alan

[ZLHysong]

The forms you see are the ones I mean. All they are intended to do at the moment is to View the Cells. No modification at all. The Tables will remain Static unless I modify the data in the table itself, by opening the Table and changing it there.

[alansidman]

Ok. I understand now. I have to run out for a couple of hours, but I will get back to you later today.

[ZLHysong]

Thank you. I appreciate that.