row highlight in table when one field accessed

[willie408]

I have to fill in the field "how many on hand" for 1600 rows in our inventory table. It would be much easier if I could make the entire row (there are 12 columns) highlight when the "how many on hand" field was active. I am not a programmer; I have used Visual Basic for Applications 8/10 times successfully but had a good sample to follow. Can you suggest where I could find a sample for this? Thank you.

 

[beetee]

An answer to your question doesn't come to mind.

I'm not sure I understand why you want to highlight an
entire row to update a single field.

Perhaps if you could state your objective in a more generic sense a good solution may be found.

 

[Rick39]

Take a look at

http://www.mvps.org/access/forms/frm0047.htm

 

[willie408]

beetee - thanks for your reply. The reason I need the whole row highlighted is that in making 1600 entries as to how many items are on hand, I have to look down the row to check that the part #, description, and vendor are the same as on the printed form from which I am entering the "on hand" amount. Unfortunately, in US medicine, manufacturers continually change the names of their products and the manufacturers themselves are frequently bought and sold so the vendor names change too. It would be much easier with a highlit line since the numbers are very complex - combinations of letters, numerals, dashes, etc. thanks anyway.

 

[willie408]

Rick39 - thanks a lot!!

 

[Rick39]

Glad it helped

 

[beetee]

The link Rick39 provided looks very useful; you have to create a form for your table; use 'continuous form' view, and you can highlight the current row.

Another method might be to toggle between form (one record at a time) and datasheet view (one record per line, multi-record).

In either case, you will need to create a form; I don't know of a way to modify a table in the way you describe.

You can highlight rows on a table by repeatedly pressing the F8 key.

HTH