Assign a value to a text box using VBAMark this reply as the best answerChoose carefully, this cant be changedIm getting really confused here. Are you working with Phil, or are we. You state that your form has many textboxes that come from two different. Then you ask how you can save the contents of the textboxes to the. My answer is that you need to do a LOT of programming to achieve. You can only bind a form to a single data source. Microsoft Access free download Download Access database examples demonstrating usefull programming techniques. Downloaded databases include How Tos for Visual Basic. FAQ zu MSAccess, AccessEntwicklerKonferenz, SQL ServerEntwicklerKonferenz. NetEntwicklerKonferenz, Infos und Downloads zur Datenbankprogrammierung. Access 2007 Dlookup Update Query Oracle' title='Access 2007 Dlookup Update Query Oracle' />Append query to multiple tables. Discussion in Microsoft Access External Data started by Guest, Jan 30, 2005. Accessvlookup. How to create an Access database with a DSNless linked table to a SQL database Автор blackcat Тема ветки поругать здесь нет Дата 02. I am trying to display the record count value of a recordset ran in VBA in a text box on a form, however, I have been unable to get the result to. That source can be a table. NOT two tables. The source can be a query you can still. However, queries that. NOT updatable. This is one of. Rob Crombie hates data binding. I am less strict. I like binding a form to a table, because you get the. AUTOMATICALLY updated when you navigate away. In fact, I have created forms that use bound controls. Record Source, for one table, and unbound controls to draw. To do so, you have to add VBA code to the form. Each time you navigate to a. Forms Current event is. You can add code to the event procedure to retrieve data and put. Each time you navigate to a different record, the Before. Update and. After. Update events are triggered. You can put code in the Before. Update event. procedure to retrieve the values from the unbound fields and store them in. Theres simply no way that I can give you any more specific information than. What you need. to do, if you want more help, is. Tell us how your tables are structured. For each table, tell us the. NAME of the table, and then list the fields in the table. For each field. tell us the NAME of the field, the datatype, and the size. Every table. should have a Primary Key field. Tell us which field in your table is the. Tell us how your tables are related to each other. If you have a. field in one table that contains a value that is the Primary Key of another. Foreign Key field. Tell us what you are trying to do with your form. Tell us the NAME. For each control, tell us. NAME of the control, what type of control it is, and what data you want. In most cases, that means what field from what. In other cases, it may be the result. Tell us what buttons you have created on your form, and be prepared. VBA code for each buttons Click event into your post so we can. Its not necessary to give us ALL this information in a single post. Michael S. Meyers Jouan idctl. Id2. 80. 90. 48. Ka. Im getting really confused here. Are you working with Phil, or are we. You state that your form has many textboxes that come from two different. Then you ask how you can save the contents of the textboxes to the. Vijay Tv Live Program Today. My answer is that you need to do a LOT of programming to achieve. You can only bind a form to a single data source. That source can be a table. NOT two tables. The source can be a query you can still. However, queries that. NOT updatable. This is one of. Rob Crombie hates data binding. I am less strict. I like binding a form to a table, because you get the. AUTOMATICALLY updated when you navigate away. In fact, I have created forms that use bound controls. Record Source, for one table, and unbound controls to draw. To do so, you have to add VBA code to the form. Each time you navigate to a. Forms Current event is. You can add code to the event procedure to retrieve data and put. Each time you navigate to a different record, the Before. Update and. After. Update events are triggered. You can put code in the Before. Update event. procedure to retrieve the values from the unbound fields and store them in. Theres simply no way that I can give you any more specific information than. What you need. to do, if you want more help, is. Tell us how your tables are structured. For each table, tell us the. NAME of the table, and then list the fields in the table. For each field. tell us the NAME of the field, the datatype, and the size. Every table. should have a Primary Key field. Tell us which field in your table is the. Tell us how your tables are related to each other. If you have a. field in one table that contains a value that is the Primary Key of another. Foreign Key field. Tell us what you are trying to do with your form. Tell us the NAME. For each control, tell us. NAME of the control, what type of control it is, and what data you want. In most cases, that means what field from what. In other cases, it may be the result. Tell us what buttons you have created on your form, and be prepared. VBA code for each buttons Click event into your post so we can. Its not necessary to give us ALL this information in a single post. Michael S. Meyers Jouan.