Search results

Does this mean I will have to link my tables for some of my queries to perform? Or will I will able to use them independently?

Private Sub School_Location_Click() Me.RecordSource.Refresh End Sub This is exactly what I have in the code (is this correct?), but an error still occurs. jim

Private Sub School_Location_Click() Me.RecordSource.Refresh End Sub This is exactly what I have in the code (is this correct?), but an error still occurs. jim

thanks PAT AND SPACEPRO, I'll give it a shot and if you don't mind I might need some assisstance throughout the process. thanks jim

Thanks for the reply, but when I tried the me.recordsource.refresh it gave a compile error, is that the only line of code I should enter or should that work? thanks jim

When I first created the database I created a look up field and I added the names of the schools I wanted to be able to click on. Now I would Like it to be possible to add new items and for it to be updated automattically to the value list. I have been working on this for 2 days now and am...

Any suggestions on some good access training that would be worthwhile to take? THANKS

I'm not sure if this is possible. I would like to set up a parameter query that will allow me to enter a student's name, even though there are other names in that field, I would still like it to bring up a query based on the name I entered. I've attatched the dbase in hopes it would hopefully...

Thank you for your reply. The expression is in the control source. I'm using the expression to avg. my students grades. The expression is =[field]/4+[field2]/4+[field3]/4+[field4]/4. It takes 4 grades that are on my form and avg. them for me. The conditions of the formatting are less than...

I have a form with some expressions and conditional formatting. I've run into a problem when I set conditional formatting in two of my fields, I recieve an error code in 2 of my other fileds. The error looks like this, #NAME. I'm still really new at this. If anyone can help I would really...

GOT IT After even more trying I was finally able to get it. I ended up using the expression of =[field 1]/2 + [field 2]/2. It works perfectly. So if you ever have to avg. even more numbers, you just divide each field by the number of fields you need to average. THANKS FOR EVERYONES REPLIES.

I have a database where I am trying to average my students grades. I have added a textbox in the form but I am unable to get the right expression to average the 2 grades. What usually happens is the 2 numbers are combined side by side. For example, if the grades were a 50 and a 50, the text...