advanced microsoft access courses in london - forms

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

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

resolvedResolved · Low Priority · Version 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:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips


Server loaded in 0.1 secs.