Forum Home
Press F1
Thread ID: 112959	2010-09-28 23:32:00	Access 2003 Data Problem	Obelix (752)	Press F1

Post ID	Timestamp	Content	User
1140310	2010-09-28 23:32:00	We have created a form that allows us to do stocktaking. This form has a link to an external visual foxpro table, that contains all of our records in stock. The form then writes to an access table with the stocktaken information. The problem I have is that if a user enters a stockcode that does not exist, they do not know. I want to insert some code into the form that tells the user that the stock code they have entered does not exist in the externally linked table. All the information I have seen refers to using a recorsource, but there is no recordsource defined as there is a link to the external data. Can anyone help me please Peter	Obelix (752)
1140311	2010-09-29 21:58:00	Hey Peter, The form you are using needs to use a Combo Box or List Box for the field where your team are inputting the Stock Code. The Combo box can be configured to hold a list of ALL the stock codes from your external Fox Pro table. Each time the Form is opened it will re-examine the list of existing Stock Codes held in Fox Pro and show a list that is up to date at that moment in time. Then the Limit To List setting of the combo box can be set to Yes. This way if they enter a code that does not perfectly match an existing code in Fox Pro they will get a message saying Value entered Is not In the List, and they are stopped in their tracks until they correct it. You can even get fancy and have the Combo box displaying other product info along with the Stock Code. Eg if the Fox Pro table contains Stock Code, Quantity, Product Description, Supplier, then any or all of this info could be shown in the Combo Box to help ensure they pick the correct item. Only the actual Stock Code info is actually entered or passed on to your other Access table via this control, despite the fact it may be displaying tons more than that. They can select the stock code by either typing it in, or scrolling through the list to select it, or a misture of both techniques... the first few characters of the stock code to zip to that part of the list, then a mouse click on the correct line--- much easier if the stock codes are lengthy or made up of characters instead of numbers.	Paul.Cov (425)
1