Schduling form - Cant store value

[Homegrownandy]

I want to create a form where a user has the option to do two things:



1. Select a record from a combo box and have the corresponding date displayed (for view or amendment)
2. Have the ability to select two dates (from + to) and then a list will appear with all the sites that have dates which fall within that parameter.

My first problem with this is...

I can create the combo box, it displays the records I want. But when it asks for me to select a value to use later, the next page is the final one where I name the box.

It doesn't ask me where I want to save the value and I am unaware how I can use a "stored value" when I have no idea where it is stored.

Hopefully someone can help. Thanks

Andy.

[ranman256]

In your line: "it displays the records I want. But when it asks for me to select a value to use later, the next page is the final one where I name the box.
do you mean, when you run the query, it will ask you to fill in a parameter?

And queries dont save the value, if you are using a form, your value goes into a control on the form. (your combo box)
it is 'stored' here for the query to read.

select * from table where [state] = forms!frmFind!cboState

Am I on the right track?

[Homegrownandy]

Perfect; I didn't know how to reference the selection made in the box, but you are correct. I don't need to store this data just use it for the query.

Thanks.

[Homegrownandy]

>=[Forms]![schedulerF]![From_Date_TXT]&<=[Forms]![schedulerF]![to_Date_TXT]

this contains an invalid syntax its saying.. any ideas what's wrong here~?

[John_G]

"&" isn't correct - you have to use the word "AND"

[CJ_London]

agree 'and' and but still not correct

myField >= [Forms]![schedulerF]![From_Date_TXT] AND myField <= [Forms]![schedulerF]![To_Date_TXT]

or

myField BETWEEN [Forms]![schedulerF]![From_Date_TXT] AND [Forms]![schedulerF]![To_Date_TXT]

[Homegrownandy]

Sorry I didn't realise you responded. I didn't get the notification.

Here's what I currently have and it seems to work:

>=[Forms]![schedulerF]![From_Date_TXT] And <=[Forms]![schedulerF]![to_Date_TXT]

Is this okay or would you recommend changing it?


Additionally; I would also like to run a query that looks from the current day and the following 7 days so we can see what's upcoming in the following week. How would I achieve this?

thanks Andy

[June7]

Maybe:

myField BETWEEN Date() AND Date() + 7

[Homegrownandy]

Where you write my field is that for the SQL? I'm keen to understand the help you offer and I don't understand the MyField part.

Other than that, thanks for your time. Ill give this a go today along with some other features.

[June7]

MyField is where you put your actual field name appropriate for the expression in SQL statement. Or in query design grid this is the field for which you apply the criteria.

[Homegrownandy]

But when I'm entering the information into the criteria box on access, it would put in this code for me right? I might be asking stupid questions but I want to understand as much as possible.

Thanks Andy

[June7]

Criteria is typed into the cell in Design View grid. Switch to SQL View to see the statement that is constructed.

[Homegrownandy]

thanks june