Highlighting a matching record in subform

[torquay]

Hopefully someone can point me in the right direction.

I am trying to highlight a matching row in a subform from the main form.

I have a popup form (mainstockform) with a subform (addinventory) to enter existing products into the db stock, when entered it updates another subform (currentstock) in the main form which shows a running total list of everything in stock, this works fine. As there are many 100's of stock items in stock at any one time the only way to check if a specific item is in stock is to scroll down the list. This is ok but a user can sometime skip over a stock item if it is very similar to another.

I would like to have a text box on the main form that a user can enter in a stock number and it will then, if in stock will highlight the line in (currentstock) subform.

Thankyou

 

[maxmangion]

have you considered using conditional formatting?

 

[torquay]

How would I go about doing that?

 

[gemma-the-husky]

i dont quite follow

-------------
have a main form, to select a product

have a subform to show transactions for products

now if the sub form is linked to the main form, this will automatically only show you the stock for the selected item

-------
now, if you are booking in stock eg - a delivery with 20 different products on, then thats a different issue - in that case you would want to see different items, but you wouldnt want to see transactions for those items

 

[torquay]

I have 2 subforms on the main form