Search results

Awesome! Not only did that work, but Screen.ActiveDatasheet.[Phone 1] pulled the contents of the Phone 1 field of the highlighted record of the open table (datasheet view, of course)

When the macro is clicked on, the Phone 2 field of the selected record (the first one) is supposed to become populated, for instance. Note that at the bottom left, the highlighted record shows up as "1 of 4". Is there any VBA command that can reference that particular data?

Here it is - the macro in question is the fourth one on the right:

The closest Excel equivalent would be a datasheet, but first and foremost, it's an open Access table where the user manually highlights a record. The code is in a macro that is clicked on by the user above the open table after a record has been highlighted.

I'm familiar with getting VBA to select a particular record in an Access table, highlighting it as the current record. But I'm at a loss to do the reverse: if the user manually selects (highlights) a record in an open Access table, how does the VBA program detect which record has been...