VBA with Tabular Forms

[deljr15]

I'm not sure if this belongs here or in the forms section. I also did not see anything applicable in the search. (tho I may not have searched the correct verbiage)

What I am trying to do is set a property of a field in a tabular form on a per line basis. I can think of lots of ways to do this in PHP just cant seem to find the answer for VBA.

Example:

txtDescription.Text = "some text"        //Line 1
txtDescription.Text = "some other text"  //Line 2

 

[mdlueck]

In Access you must bind your Multiple Items to a tabular recordset, and in that is where you place each of those entries.

You may bind forms to a table, or a query.

So if you wanted to not have the records in an actual table, I suppose you could build a SQL statement which could be placed into the recordsource form property, and thus populate the multiple items form.

We do not know enough of what you are trying to do in order to make specific suggestions.

 

[deljr15]

Thanks for the response. What this is for is to insert a description of a item. It will get the data from a table storing item properties (properties may be a bad word to use here) the table consists of ID, Item_Id, Description, Value. I then pull all the data from the Inventory_Data table where Item_Id = the item id for that line of the PO. I then concat the data into a description to be inserted into that field.

In my mind I keep thinking of a PHP foreach loop but just can't seam to get my head wrapped around this in VBA

Edit: I will be looking into the concat() function in MS SQL

 

[mdlueck]

In my mind I keep thinking of a PHP foreach loop but just can't seam to get my head wrapped around this in VBA

In Access, Forms and Reports have a single record object, and then that is duplicated n times for n row instances.

All of the row control names are always the same.

For color highlight capabilities, for example, you must work within the confines of the Conditional Formatting capabilities of Access Multiple Items forms. You can not go off and use VBA code to perform the conditional coloring along the lines of the code you proposed in your OP.