I have a created a query that filters a table. The data is shown is CustomerID,FName,SName. There is a Field that alread has the CustomerID in and i have a button to open the query with the criteria of what ever the ID is in the CustomerID field. This all works great but how do i go about putting the FName and SName data into the relevant fields using the same button?
How to put data from query into certain fields?
- Thread starter Topham
- Start date
Steve R.
Retired
- Local time
- Today, 16:45
- Joined
- Jul 5, 2006
- Messages
- 5,748
When a form is bound to a query, you usually have two way communication with your query. (I should also mention that certain queries do not directly allow the saving of data.) You can both retrieve data from the query and put your data results "into the relevant 2 fields". So if your query contains those two fields updating is simple.
If you don't want your form to be bound to a query you can create a DAO recordset based on the table(s) holding those two fields and save your data to the recordset.
