Fill information on Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My database is tracking tax documents...

I have a subform, that has about 4 columns
Column 1 is DocumentType (e.g., W2, 1040, 1090)
Column2 is DocumentYear (e..g., 2001,2002,2003 etc)
Column 3 is DocumentStatus(e.g., (Pending, Canceled, Completed)
Column 4 is DocumentRcvdDate(e.g., 12/20/2005 11:25 AM)

What I would like to do is that when I select documents W2, 1040 and 1090
(this are all different rows) and only input one DocumentRcvdDate in the
first row(e.g., it might contain W2), I would like to have a button that if I
press, it will use that date and time and update the other rows which might
have 1040 and 1090.... How will do that?

Please help!
 
Move to the blank field in the next row and press Ctrl-' (that's the
single-quote/double-quote key).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort table on criteria 4
if student number repeats move all data for that number on to same 1
Multiple Sums Depending on a description. 9
Problem with advanced filter macro 8
Copying formulas in a Macro 5
Update a date on main Form 2
Figuring out a lengthy formula. Probably quite simple... 3
VBAscript for data matching excels 0

Back
Top