Creating a Form

  • Thread starter Thread starter poppybush
  • Start date Start date
P

poppybush

I am used to using Access via web applications created in ASP and
ASP.NET. This means that I don't much experience creating forms in
Access. I understand the whole concept of stored procedures and am
trying to work that into this form I am creating. I want to have a
command button that opens a form titled frmASL. When I click this
command button I want a msgbox to prompt the user for query string.
After the user presses ok a form is displayed with the matching
results(if any). Anyone know of a good site to help me with this
matter or a relevant example?

Thanks in advance.

- paul
 
I am used to using Access via web applications created in ASP and
ASP.NET. This means that I don't much experience creating forms in
Access. I understand the whole concept of stored procedures and am
trying to work that into this form I am creating. I want to have a
command button that opens a form titled frmASL. When I click this
command button I want a msgbox to prompt the user for query string.
After the user presses ok a form is displayed with the matching
results(if any). Anyone know of a good site to help me with this
matter or a relevant example?

Thanks in advance.

- paul
Click to expand...

paul,

There are several newsgroups for asking questions about forms:

microsoft.public.access.forms

or

microsoft.public.access.gettingstarted


Questions about VBA on forms can be answered at:

microsoft.public.access.formscoding


Sincerely,

Chris O.
 
Create a pop-up form named PFrmASLCriteria with a textbox named ASLCriteria.
Put a button on that form with the following code in the Click event:
DoCmd.Close
Put this code in the AfterUpdate event of the textbox:
Me.Visible = False

Base FrmASL on a query. Put the following expression in the criteria of the
ASL field:
Forms!PFrmASLCriteria!ASLCriteria

Put this code in the Open event of your FrmASL:
DoCmd.OpenForm "PFrmASLCriteria",,,,,acDialog
If Not IsOpen("PFrmASLCriteria") Then
Cancel = True
Exit Sub
End If

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you don't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
 
Back
Top