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

advanced microsoft access courses in london - forms

Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced microsoft access courses in london - Forms

advanced microsoft access courses in london - Forms

ResolvedVersion Standard

David has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Forms

I asked this question on Monday and have had no answer yet, can somebody please come back to me on this:

"I have built my tables and created a form based on these tables containing dropdown boxes as options for the completion of this form. How do I choose where the information on the form is saved?

ie I have filled in my form, on saving this I want it to save the data in a raw data table that I can then run reports off."

RE: forms

Hi David

The form source is where the information information is saved ie the table field that you bound text box control is bound to or the option control you have selected. If you have a field called status and you have a combox box to change the staus then the combo box control source should be bound to that field. Then run report on query based from that table.

Hope this helps.

Regards

Best Training

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

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.12 secs.