Form controls

[Caesar Augustus]

Greetings all!

Before I ask a question I will try to provide a little background. I
am currently working on an app(PD) that is essentially a search engine
to find specific records. Once the record is found and data is
verified, the user transfers it to another pre-existing
application(AP).

Front end for both apps is Access 97 while the backend is SQL2000.

As for my question. After I transfer the record over to the
pre-existing app(AP) I need to be able to set a combo box control
value in one of its forms to the key value of the record transferred.
The combo box in question is the criteria value for the query that
feeds the detail form that I want to open.

The limitation I have is that I can't modify the current application
since not all users will receive the new search tool. Therefore, I
need to find a way to do this all from a module within the new
app(PD).

Hopefully my explaination wasn't to vague...trying not to overload the
description with needless details.

Any support is greatly appreciated and for this I thank you in
advance.

-madmax

[Salad]

Caesar Augustus wrote:

Greetings all!

Before I ask a question I will try to provide a little background. I
am currently working on an app(PD) that is essentially a search engine
to find specific records. Once the record is found and data is
verified, the user transfers it to another pre-existing
application(AP).

Front end for both apps is Access 97 while the backend is SQL2000.

As for my question. After I transfer the record over to the
pre-existing app(AP) I need to be able to set a combo box control
value in one of its forms to the key value of the record transferred.
The combo box in question is the criteria value for the query that
feeds the detail form that I want to open.

The limitation I have is that I can't modify the current application
since not all users will receive the new search tool. Therefore, I
need to find a way to do this all from a module within the new
app(PD).
Then what is the problem? If you have 3 users and only 1 will receive
the new front end app, do you really care? It almost sounds like you'l
have 2 versions, 1 for those that can search, another for those that
can't. Over time, that could be a PITA to monitor.

Do you have User-level security? If so, you could create a group that
has access to the the search form. Then check to see if the user logged
on is a member of the group. If so, make visible the button to call the
search form. If not, keep the button to call the search form invisible.

Regarding how to update. I assume the combo rowsource is based upon a
table. Upon transfer, add the new key to a table or else update the
flag to note the transfer. Then check if the form is open and if so use
the
Forms!FormName!Combo.Requery
to refresh the combo.

Hopefully my explaination wasn't to vague...trying not to overload the
description with needless details.

Any support is greatly appreciated and for this I thank you in
advance.

-madmax