forms

C

Chi

Hi,
I would like to learn to create a custome form.

The form has 3 boxes: Code#, Description, and charge.
When I enter the code #, 99999, on the CODE text box, Its will
automatically show its description at DESCRIPTION tex box and then soon the
Description appears, its price will show at CHARGE tex box, too.

Ex: On the form, after I type in Code# 99999, automatically will show "
Physical Exam" on DESCRIPTION box and 50$ will show on Charge box.
Is there a way to do that? Do I need to work with coding?
Thank you so much
Chi
 
R

Rick B

Check out the Northwinds database. Several of the forms have this
functionality. Check out the "ORDERS" form and notice what happens with the
addresses when you select a vendor.
 
M

Mike

Hi Chi

There is a way of getting this to occur. If you create your table with the 4
fields required:
pkCourseID
Code
Details
Charge

Then create a blank Form and switch to design view

In design view create a combo box and then right click on the box to go to
properties.



Row Source =
SELECT Courses.pkCoursesID, Courses.Code, Courses.CourseDescription,
Courses.Charge, * FROM Courses;

Column Cout = 4

Column Widths = 0cm;1cm;5cm;1cm

Bound Column = 1

When you now switch to FForm View the combo box will pull up all 3 columns

To get the Charge to appear in anoth form field - Switch to Design View

Create an Unbound Control - Right click on the control and select properties.

Control Source = =[Courses].[column](3)

Let me know how you get on


Regards

Mike
 
C

Chi

Thanks Mike,
I got the combo box. It pulled up all 3 columns. However, I can not get
the Charge appear in another form field.
I entered = [Courses].[Column](3) in unbound texbox at design view, and
switch to form view.

The textbox shows (# Name?). Please show me how to fix the problem.
Thank you so much, Mike
Chi Huynh


Mike said:
Hi Chi

There is a way of getting this to occur. If you create your table with the 4
fields required:
pkCourseID
Code
Details
Charge

Then create a blank Form and switch to design view

In design view create a combo box and then right click on the box to go to
properties.



Row Source =
SELECT Courses.pkCoursesID, Courses.Code, Courses.CourseDescription,
Courses.Charge, * FROM Courses;

Column Cout = 4

Column Widths = 0cm;1cm;5cm;1cm

Bound Column = 1

When you now switch to FForm View the combo box will pull up all 3 columns

To get the Charge to appear in anoth form field - Switch to Design View

Create an Unbound Control - Right click on the control and select properties.

Control Source = =[Courses].[column](3)

Let me know how you get on


Regards

Mike

Chi said:
Hi,
I would like to learn to create a custome form.

The form has 3 boxes: Code#, Description, and charge.
When I enter the code #, 99999, on the CODE text box, Its will
automatically show its description at DESCRIPTION tex box and then soon the
Description appears, its price will show at CHARGE tex box, too.

Ex: On the form, after I type in Code# 99999, automatically will show "
Physical Exam" on DESCRIPTION box and 50$ will show on Charge box.
Is there a way to do that? Do I need to work with coding?
Thank you so much
Chi
Click to expand...
Click to expand...
 
M

Mike

Hi Chi

Re the error msg #Name

It is probably just the syntax

Try =[Courses].Column(3) vice =[Courses].[Column](3)

Let me know what happens

Regards

Mike
 
M

Mike

Hi Chi

It could also indicate that your name for the combo box is the same as that
used for the Table? Always name your text box using the syntax
txtNameofTextbox

Cheers

Mike
 
Top