Access Lookup Field not updating! Please help!

[MPatron]

Hi

I need help!

I have created a database with a number of tables. I have created one table with job name (tbl_TFR) as a field and another table that has job field and and salary (tbl_STI). I have used a lookup field in tbl_STI that looks at tbl_TFR's job name (so the user in a form can only select job name from the list that is populated by another user in tbl_TFR).

I have created a form based on the above two tables.

When I populate the job name in the form for tbl_tfr and then flip to the form for tbl_STI, I can see the job name in the drop down list. If I flip back and populate another job name in tbl_TFR, I cannot see it in tbl_STI unless I close the form and then reopen it. Do you know why?

 

[Crowley16]

you need to put an me.requery into the after update event of your drop down box...


--------------------
Procrastinate Now!

 

[MPatron]

Thanks so much for the response! How do I go about doing this? I am not sure what an me.requery is. Thanks

 

[MPatron]

Hi Crowley16

Thanks so much for your help. I worked out the me.requery and now it is working perfectly!! I really appreciate your help. Can I ask another question? I need to calculated percentiles for data in my database. I understand that there is no formula for this in Access (as opposed to Excel) and I would need to enter some code to be able to generate the result. My problem is that I do not know where to put the code and how to call it up in Access? All I need to do is query a set of data and calculate the 25th, 50th and 75th percentiles. Can you help?

 

[pattyjean]

you can calcuate in the query or the form

Query: Add new field names example
TFR25:[TFR]*.25
TFR75:[TFR]*.75

 

[MPatron]

Hi pattyjean

Thanks. but won't this just multiply the data field by 25% or 75%? I need to find the value that sits at the 25th% position of the data. In other words, in the data, the value sits at the position where 25% of the data sits below it and 75% above. Does this make sense?