Command: Data, Form

  • Thread starter Thread starter David Goldsmith
  • Start date Start date
D

David Goldsmith

I would like to customize the dialog box associated with this command
such that the empty field entry boxes which result from selecting
"new" are equipped with pull downs whose options are field values
already in that field column. Here's what I actually want to do: I
manage a tutoring center and need to keep track of who comes in, when
they come in and leave, what class they're coming in for help with,
and the associated instructor. In order to make later sorting and
other analyses easier, I'd like to reduce the variation in how people
identify themselves when they sign in, and thus have them use a pull
down to select their name if they have signed in before (I'd also
still need the empty field option for first timers). In addition, I'd
like to have pull downs for the class and instructor entry boxes which
draw from a preset array of choices (the faculty and courses are
essentially fixed), and automatic entry of the "now" function into the
time in time out fields. Any suggestions?

DG
 
As Far As I Know.

multipost = send the same message separately to > 1 group. One can spend 5 -
10 minutes working on a question in one group w/out knowing it's already
been picked up in another group. In fact you cross-posted which isn't so
bad, so my mistake & apologies.

If you're new to groups, you could check this link for how to get the best
out of them -

http://www.cpearson.com/excel/newposte.htm

Rgds,
Andy
 
Back
Top