Re: please help a newbie solving a problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

1. I will find a way to do that.
2. how do I refresh the screen, assuming the screen name is avit, I can
close it by doing:
docmd.close
and then reopon it by using docmd.open("avit")
but how do i requery it ?
so far i am using me.requery but as the focus changes i need to use
something else and i don't know what.
thanks for the help

"NetworkTrade" <NetworkTrade@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5261F031-F70E-42D9-A577-B48EE3BC2B4D@xxxxxxxxxxxxxxxx
1. if I don't select a default salesperson name - the form will load
empty,
and will not let me do anything.

*** this seems logically correct i.e. no name - no data..... you could
put
in some code that pops-up a warning that no salesname has been selected;
but
I can't determine whether you can change this behavior based on only this
info..... if you don't have experience with message boxes you might
simply
add a label in RED CAPS to remind the person to highlight a name before
selecting.....


2. if I define a default name, the form will let me choose different
salesperson, but the appropriate data will not change meaning if I
selected
a sales person with 8 different type of activities, it will display all 8
of
them but then when I select a sales person with 4 type of activities the
system will replace the data with the appropriate lines but will live the
remaining activities on the screen

**** I would try just refreshing the screen by using a macro on whatever
button/event creates the change in data to first close the form, then
re-open
the form based on the new entry....it won't be perceivable

--
NTC


"Rani" wrote:

guys, this is the third time I post the same question, and I do apologize
for it.
I crated a form based on a query.
in the form - a continues form - I display the information pretends to a
salesman according to his activities per month.
the form as an unbound combobox based on the salesperson name from the
query. I declared an afterupdate event in which I run the requery
(me.requery)
I have few issues with this form:
1. if I don't select a default salesperson name - the form will load
empty,
and will not let me do anything.
2. if I define a default name, the form will let me choose different
salesperson, but the appropriate data will not change meaning if I
selected
a sales person with 8 different type of activities, it will display all 8
of
them but then when I select a sales person with 4 type of activities the
system will replace the data with the appropriate lines but will live the
remaining activities on the screen

what do I do ?





.

Relevant Pages

  • Re: please help a newbie solving a problem
    ... my form is a form based on a query ... salesperson, but the appropriate data will not change meaning if I ... a sales person with 8 different type of activities, it will display ...
    (microsoft.public.access.gettingstarted)
  • please help a newbie solving a problem
    ... I crated a form based on a query. ... if I don't select a default salesperson name - the form will load empty, ... a sales person with 8 different type of activities, it will display all 8 of ... them but then when I select a sales person with 4 type of activities the ...
    (microsoft.public.access.gettingstarted)
  • Re: please help a newbie solving a problem
    ... a macro is pretty easy. ... not sure if your screen is form or query or report or what - - but in any ... a sales person with 8 different type of activities, ... the form as an unbound combobox based on the salesperson name from the ...
    (microsoft.public.access.gettingstarted)
  • Re: cant find the how-to steps for query results I need
    ... What are the field types of the Step fields and the Sold field? ... You can build this query in design view. ... I have a table that basically reads like this...date, salesperson, step 1, ... I need to create a query that spits out the numbers for each sales person on a month to date basis. ...
    (microsoft.public.access.gettingstarted)
  • Re: Create a Calcuated field in a query
    ... Group by for salesperson, then sum the totals and it should be soup. ... I have an Invoice Database ... There can be multiple Sales Reps per ... > I've started a query based on the SalesPersonInvoice table. ...
    (microsoft.public.access.queries)