A
Alan
I want users to be able to name the switchboard. I added a new field in the
switchboard items table called name and changed the labels to txtboxs with a
record source to name. If this isnull a form opens which allows the user to
put a name into an unbound txtbox. When the form closes the values are
transferred to the name txtbox on the switchboard. However, this only works
for the first page of the switchboard. It has to be placed in all the command
fields that = 0 for it to show on all the pages of the switchboard. I can't
get an update qry to work - syntax problems. This and several other versions
were put in the onclose event. Thanks in advance for any help.
CurrentDb.Execute "UPDATE [Switchboard Items] SET WHERE [command]= 0 And
[name] = " & Me![name] & "
switchboard items table called name and changed the labels to txtboxs with a
record source to name. If this isnull a form opens which allows the user to
put a name into an unbound txtbox. When the form closes the values are
transferred to the name txtbox on the switchboard. However, this only works
for the first page of the switchboard. It has to be placed in all the command
fields that = 0 for it to show on all the pages of the switchboard. I can't
get an update qry to work - syntax problems. This and several other versions
were put in the onclose event. Thanks in advance for any help.
CurrentDb.Execute "UPDATE [Switchboard Items] SET WHERE [command]= 0 And
[name] = " & Me![name] & "