Default Values

[wolvesmatt]

Hi
The database is all about an athletics league, and i have set up a form for a query that i have made. When I open the form, i get the parameter box asking me which Venue ID i would like to choose, now what i would like is, whatever i type into that box to become the default value in one of the fields in the form.

i think that makes sense


Thanks In Advance

MATT

 

[alastair69]

If you can post your database i will have a look for you!

Alastair

 

[wolvesmatt]

here u go, the form is "selection query" and i want the field "meeting Id" thats in the form to show whatever i typed in the parameter query.


Thanks

 

[alastair69]

Do you mean when a new record is added to your database

 

[wolvesmatt]

yes please

 

[alastair69]

The way your query has been setup the value of your parameter box is not saved and there for it you need to use the value again it has not saved it so it is lost.

One way around this would be to create a form that will hold the value and then pass it on, would you like to make a simple form that will allow you to do this?

Alastair

 

[wolvesmatt]

please, but im not that brilliant with access

 

[alastair69]

On your Menu form could you have the Venue ID?

 

[wolvesmatt]

im not 100% on what you mean but i dont think so

 

[alastair69]

If you have a look on the form Venue and press the seletion button this should give you an idea of how to complete your task.

If you need any more help feel free to ask.

Alastair

 

[wolvesmatt]

i thin k i have found a way around the problem


Thanks for all your help