code for view button.

[buggy2]

hello, firstly i am a novice when it comes to vb for ms access code but well up on vb and vb for excel. I have a form with a number of combo boxes, on the first the user selects the day of the week and on the second the time of day by hour.

I now have a button and when this is clicked I wish to show all the records which fit the criteria in the same manner as a query would.(i.e. all the data that was entered into the database at 12pm on friday for example.) Data loaded every hour.

I expect this is very easy, but I have never had to use this before an its a one off.

 

[Dugantrain]

If I understand your problem right, build a query which captures the fields that you want captured (in this case, Date, Time, and whatever else you need). In the criteria under Date, write:
Forms![YourDataEntryForm].Form![YourDateComboBox]
Under Time write:
Forms![YourDataEntryForm].Form![YourTimeComboBox]
Now, using the wizard, put a command button on the form, Miscellaneous, Run Query, select the query that you just wrote. This will filter your recordset to only what you have selected in the Combo Boxes.

 

[buggy2]

view button

that worked great thanks,