Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access course - combo boxes data access

Forum home » Delegate support and help forum » Microsoft Access Training and help » access course - Combo boxes in Data Access Pages

access course - Combo boxes in Data Access Pages

ResolvedVersion Standard

Ricardo has attended:
Access VBA course
Access Advanced course

Combo boxes in Data Access Pages

Hi

Once you have created data access page, is it then possible to have that data access page retrieve and display data records using a combo box as a search box? (I.e. is it possible to duplicate the "retrieve-records-based-on-a-combo-box-functionality" in a form, but in a data access page format?)

Thanks

Ricardo

RE: Combo boxes in Data Access Pages

Data access pages are generally very simple in their layout. What I notice about them is that there is no EVENT tab on the properties box, so it is challenging to copy the functionality that you could build into a form using a drop down and command button.

I am not familair with VBA and what it could do in this case.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.