Enter Parameter Value

[timwagg]

Hi,

Before you get annoyed at me I have been searching for the answer to this questions for weeks now and have got no where.

I have tried the Microsoft fixes and everything I can find on the forums, but nothing.

I basically have a form (Registration) with a number of combo boxes (FlightDate, FlightDateOut) which have a row source of a query I made based on the table flights.

The problem I am having is that everytime I try and save and close the form, so I can see the data I have inputted in a form called Attendees (with a subform which displays reg data) the data shows but I can errors asking for Parameters.

I'm sure it is something to do with my row sources but I am not experienced enough to know what code I need to put in there. If I try to manually put in the code e.g. Flights.FlightID, Flights.FlightCode etc etc I still get the same error even when I add in FROM Flights at the end so it knows where to look.

Has anyone got any ideas. I can upload my database if anyone could have a look for me. I am really stuck on this problem and after this all I need to do is design reports.

Many Thanks in advance

Tim Wagg

 

[rainman89]

Hi,

Before you get annoyed at me I have been searching for the answer to this questions for weeks now and have got no where.
...I can upload my database if anyone could have a look for me. I am really stuck on this problem and after this all I need to do is design reports.

Many Thanks in advance

Tim Wagg

we dont get annoyed, we are here to help. upload it, someone will have a look

 

[missinglinq]

Upload it and give us the version you're running, so people will knoiw whether they can open it or not. The fact that Parameters are being asked for means that you have a query or queries running that cannot find one or more of the fields they reference. THis could be because the field doesn't exist, did exist and was deleted from the table but not deleted from the query, or because the field name is misspelled.

 

[timwagg]

hi,

i have tried to compress the database and then zip it up but it still comes to 430kb so it won't let me upload...any suggestions?

 

[Mike375]

hi,

i have tried to compress the database and then zip it up but it still comes to 430kb so it won't let me upload...any suggestions?

Make a blank DB and just import into to the blank ID the bits that relate to your question. If there is a big table with lots of records then delete most of them. Then compact the db and zip.

 

[timwagg]

ok here it is. i have stripped it down to get it online but it should work ok.

the problem i am having is when you open the attendees, then register to event, and then i select a flight and then a date it come up with the error.

thanks in advance

tim

 

[rainman89]

the refresh page in your macro is causing you the problems. its trying to refresh the page that you just closed. Hence the error.

 

[timwagg]

cheers!

thanks so much, can't believe it was something so stupid like that, kinda makes me feel better about my coding now!

have a great weekend!

 

[rainman89]

thanks so much, can't believe it was something so stupid like that, kinda makes me feel better about my coding now!

have a great weekend!

its only thursday