Collate information from a form and search for it on another (1 Viewer)

[james_liv]

Afternoon,

2nd post of the day. As I said on my other post I am converting or re-writing an old Lotus Approach database.

I have a customer database which books repairs to people properties.

On a seperate form from the main one I have it so you can choose to enter a date and time (AM or PM) and it searches for all the jobs that were on that matches displays it on a kind of summary form, a front sheet so to speak. I also have a field saying "Book Delivery Y/N" so obviously it checks this field too.

Any ideas how I might achieve something similar? I just need to be able to select the criteria for the search then display it but im really not sure how I build this into a query.

Many thanks

 

[arnelgp]

adding Time component may or may not produced the desired result you need.

you create a Query with the Criteria using the Form's Control, eg:

Select * from Table Where DateField = Forms!YourFilteringFormName!DateTextbox;

 

[james_liv]

adding Time component may or may not produced the desired result you need.

you create a Query with the Criteria using the Form's Control, eg:

Select * from Table Where DateField = Forms!YourFilteringFormName!DateTextbox;

The time element is just AM or PM.

Im not sure what you mean. Do you have an example?

 

[theDBguy]

The time element is just AM or PM.

Im not sure what you mean. Do you have an example?

Hi James. Belated welcome to AWF! See if any of the demoes from the following link helps. Good luck!

UtterAccess.com

www.utteraccess.com

 

[james_liv]

adding Time component may or may not produced the desired result you need.

you create a Query with the Criteria using the Form's Control, eg:

Select * from Table Where DateField = Forms!YourFilteringFormName!DateTextbox;

Thank you,

I think this has provided the solution.

I put together a quick test database and it worked so I'll try to implement it tomorrow and post back an update

 

[james_liv]

Thanks all, took a bit for me to understand how that worked but like most things, through trial and error of the solution arnelgp suggested I did manage to get it working.

Cheers

 

[theDBguy]

Thanks all, took a bit for me to understand how that worked but like most things, through trial and error of the solution arnelgp suggested I did manage to get it working.

Cheers

Hi. Congratulations! Good luck with your project.