HELP PLEASE -- combo box problems

[jwr]

My apologies for creating a new post. I have not gotten a reply and
regardless of my changes, I cannot get this to work. Can someone please
comment? Many thanks in advance. JR


I just realized that I did not give you both of my SQL views:

This one works:

SELECT DISTINCTROW [Order Details].OrderDetailID, [Order Details].OrderID,
[Order Details].LineItem, [Order Details].ProductID, [Order
Details].SerialNum, [Order Details].Quantity, [Order Details].UnitPrice,
[Order Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total], Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg, [Order Details].Notes
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

The one below does not work.
The one difference I see is the change from Product ID to Product Name.

I have a subform which has a field with a combo box. I want to change the combo box to another field on the form.

I have changed the original combo box to a text box and created a combo box for the desired field.

When I do this, I now can no longer enter info into the first field of my
form, but if I go past it, I get message that it does not have info in
Dealer table. I did not change any field except the two boxes. Below is the SQL from my form:


SELECT DISTINCTROW [Order Details].OrderDetailID, [Order Details].OrderID,
[Order Details].LineItem, Products.ProductName, [Order Details].SerialNum,
[Order Details].Quantity, [Order Details].UnitPrice, [Order
Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total], Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

Thank you,
Joy

 

[Jeff Boyce]

I don't understand. "I can no longer enter info" could mean that you can
type in the form control, but it doesn't "stick". Or that you can't type
anything - the control rejects data entry. Or you can type, but you get an
error message (which says ????). Or ...??

What happens if you delete both controls from the form? Does it work
(except for what's missing in those two controls)?

What happens if, after deleting both, you open the form in design mode and
add a control from the list of available data elements? Are the two fields
you want listed as available data elements?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

My apologies for creating a new post. I have not gotten a reply and
regardless of my changes, I cannot get this to work. Can someone please
comment? Many thanks in advance. JR


I just realized that I did not give you both of my SQL views:

This one works:

SELECT DISTINCTROW [Order Details].OrderDetailID, [Order Details].OrderID,
[Order Details].LineItem, [Order Details].ProductID, [Order
Details].SerialNum, [Order Details].Quantity, [Order Details].UnitPrice,
[Order Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total], Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg, [Order Details].Notes
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

The one below does not work.
The one difference I see is the change from Product ID to Product Name.

I have a subform which has a field with a combo box. I want to change the combo box to another field on the form.

I have changed the original combo box to a text box and created a

combo
box for the desired field.

When I do this, I now can no longer enter info into the first field of my
form, but if I go past it, I get message that it does not have info in
Dealer table. I did not change any field except the two boxes. Below is the SQL from my form:


SELECT DISTINCTROW [Order Details].OrderDetailID, [Order Details].OrderID,
[Order Details].LineItem, Products.ProductName, [Order Details].SerialNum,
[Order Details].Quantity, [Order Details].UnitPrice, [Order
Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total], Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

Thank you,
Joy

 

[jwr]

Sorry I did not explain in detail.

I can no longer enter info -- the control rejects data entry -- will not
accept ANY entry. It acts as if the field is locked; however, I have gone
back and verified that it is not. I also discovered that if I have no line
item number, the form will not allow any data entry in any other field
either. Using the form that has the combo box on the Product Name will
allow entry in all fields even if I do not have a line item number.

If I delete these fields, the form does the same thing. No data entry
allowed. Fields are available from the data elements.

If I reenter the fields from data elements, I get the same thing.

Hope this is clearer. I have only created one other form so please bear
with me.
JR

I don't understand. "I can no longer enter info" could mean that you can
type in the form control, but it doesn't "stick". Or that you can't type
anything - the control rejects data entry. Or you can type, but you get an
error message (which says ????). Or ...??

What happens if you delete both controls from the form? Does it work
(except for what's missing in those two controls)?

What happens if, after deleting both, you open the form in design mode and
add a control from the list of available data elements? Are the two fields
you want listed as available data elements?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

My apologies for creating a new post. I have not gotten a reply and
regardless of my changes, I cannot get this to work. Can someone please
comment? Many thanks in advance. JR


I just realized that I did not give you both of my SQL views:

This one works:

SELECT DISTINCTROW [Order Details].OrderDetailID, [Order Details].OrderID,
[Order Details].LineItem, [Order Details].ProductID, [Order
Details].SerialNum, [Order Details].Quantity, [Order Details].UnitPrice,
[Order Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total], Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg, [Order Details].Notes
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

The one below does not work.
The one difference I see is the change from Product ID to Product Name.


I have a subform which has a field with a combo box. I want to

change
the combo box to another field on the form.

I have changed the original combo box to a text box and created a

combo
box for the desired field.

When I do this, I now can no longer enter info into the first field

of
my

form, but if I go past it, I get message that it does not have info in
Dealer table. I did not change any field except the two boxes.

Below
is the SQL from my form:

SELECT DISTINCTROW [Order Details].OrderDetailID, [Order Details].OrderID,
[Order Details].LineItem, Products.ProductName, [Order Details].SerialNum,
[Order Details].Quantity, [Order Details].UnitPrice, [Order
Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total],
Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

Thank you,
Joy

 

[Jeff Boyce]

Were I in your situation, I'd probably be inclined to "start over".

I'd create a new form, based on the query (on the table). I'd add fields.
I'd confirm that the form is set up either to look up data or for data entry
(you can also add functionality to switch back/forth).

Sometimes, somehow, Access forms and reports can become subtly corrupted,
but still appear "normal", except for their functioning. I haven't been
able to spot how/when that happens, and realistically, I don't care. I tend
to operate on the basis of "if it doesn't work, don't spend a lot of time
trying to make it work. Find something (else) that will work..." Personal
philosophy, though, and may not match yours.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Sorry I did not explain in detail.

I can no longer enter info -- the control rejects data entry -- will not
accept ANY entry. It acts as if the field is locked; however, I have gone
back and verified that it is not. I also discovered that if I have no line
item number, the form will not allow any data entry in any other field
either. Using the form that has the combo box on the Product Name will
allow entry in all fields even if I do not have a line item number.

If I delete these fields, the form does the same thing. No data entry
allowed. Fields are available from the data elements.

If I reenter the fields from data elements, I get the same thing.

Hope this is clearer. I have only created one other form so please bear
with me.
JR

I don't understand. "I can no longer enter info" could mean that you can
type in the form control, but it doesn't "stick". Or that you can't type
anything - the control rejects data entry. Or you can type, but you get an
error message (which says ????). Or ...??

What happens if you delete both controls from the form? Does it work
(except for what's missing in those two controls)?

What happens if, after deleting both, you open the form in design mode and
add a control from the list of available data elements? Are the two fields
you want listed as available data elements?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

My apologies for creating a new post. I have not gotten a reply and
regardless of my changes, I cannot get this to work. Can someone please
comment? Many thanks in advance. JR


I just realized that I did not give you both of my SQL views:

This one works:

SELECT DISTINCTROW [Order Details].OrderDetailID, [Order Details].OrderID,
[Order Details].LineItem, [Order Details].ProductID, [Order
Details].SerialNum, [Order Details].Quantity, [Order Details].UnitPrice,
[Order Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total],
Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg, [Order Details].Notes
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

The one below does not work.
The one difference I see is the change from Product ID to Product Name.


I have a subform which has a field with a combo box. I want to change
the combo box to another field on the form.

I have changed the original combo box to a text box and created a combo
box for the desired field.

When I do this, I now can no longer enter info into the first

field

of

info

in

Dealer table. I did not change any field except the two boxes. Below
is the SQL from my form:


SELECT DISTINCTROW [Order Details].OrderDetailID, [Order
Details].OrderID,
[Order Details].LineItem, Products.ProductName, [Order
Details].SerialNum,
[Order Details].Quantity, [Order Details].UnitPrice, [Order
Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total],
Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

Thank you,
Joy

 

[jwr]

I agree with you.

I did attempt to create a new form. Here is the problem that I am running
into.

I have all fields as follows:

LineItem
ProductName
Quantity
UnitPrice
ExtendedPrice
Notes

I then add a combo box: ProductCode with 3 columns to look up information
with ProductCode, ProductName, and UnitPrice.

How do I get the name and unit price to automatically be inserted into those
fields?

You said a form can be either look up data or data entry and that I can add
functionality to switch back/forth. I have never done this. Can you please
tell me how or where to look for information?

Thanks again.
JR

Were I in your situation, I'd probably be inclined to "start over".

I'd create a new form, based on the query (on the table). I'd add fields.
I'd confirm that the form is set up either to look up data or for data entry
(you can also add functionality to switch back/forth).

Sometimes, somehow, Access forms and reports can become subtly corrupted,
but still appear "normal", except for their functioning. I haven't been
able to spot how/when that happens, and realistically, I don't care. I tend
to operate on the basis of "if it doesn't work, don't spend a lot of time
trying to make it work. Find something (else) that will work..." Personal
philosophy, though, and may not match yours.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Sorry I did not explain in detail.

I can no longer enter info -- the control rejects data entry -- will not
accept ANY entry. It acts as if the field is locked; however, I have gone
back and verified that it is not. I also discovered that if I have no line
item number, the form will not allow any data entry in any other field
either. Using the form that has the combo box on the Product Name will
allow entry in all fields even if I do not have a line item number.

If I delete these fields, the form does the same thing. No data entry
allowed. Fields are available from the data elements.

If I reenter the fields from data elements, I get the same thing.

Hope this is clearer. I have only created one other form so please bear
with me.
JR

I don't understand. "I can no longer enter info" could mean that you can
type in the form control, but it doesn't "stick". Or that you can't type
anything - the control rejects data entry. Or you can type, but you

get
an

error message (which says ????). Or ...??

What happens if you delete both controls from the form? Does it work
(except for what's missing in those two controls)?

What happens if, after deleting both, you open the form in design mode and
add a control from the list of available data elements? Are the two fields
you want listed as available data elements?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


My apologies for creating a new post. I have not gotten a reply and
regardless of my changes, I cannot get this to work. Can someone please
comment? Many thanks in advance. JR


I just realized that I did not give you both of my SQL views:

This one works:

SELECT DISTINCTROW [Order Details].OrderDetailID, [Order
Details].OrderID,
[Order Details].LineItem, [Order Details].ProductID, [Order
Details].SerialNum, [Order Details].Quantity, [Order Details].UnitPrice,
[Order Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total],
Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg, [Order Details].Notes
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order
Details].ProductID
ORDER BY [Order Details].LineItem;

The one below does not work.
The one difference I see is the change from Product ID to Product Name.


I have a subform which has a field with a combo box. I want to change
the combo box to another field on the form.

I have changed the original combo box to a text box and created a
combo
box for the desired field.

When I do this, I now can no longer enter info into the first

field

of
my
form, but if I go past it, I get message that it does not have

info

in
Dealer table. I did not change any field except the two boxes. Below
is the SQL from my form:


SELECT DISTINCTROW [Order Details].OrderDetailID, [Order
Details].OrderID,
[Order Details].LineItem, Products.ProductName, [Order
Details].SerialNum,
[Order Details].Quantity, [Order Details].UnitPrice, [Order
Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total],
Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg
FROM Products INNER JOIN [Order Details] ON Products.ProductID =
[Order
Details].ProductID
ORDER BY [Order Details].LineItem;

Thank you,
Joy

 

[Jeff Boyce]

Aha! I see one thing you can do that may simplify your task.

Since you are using a lookup (combo box) for Product-related information,
you may not need to store the ProductName and UnitPrice in the LineItem
table. Would it meet your needs to simply store the ProductID? That way,
you'd not be storing the same facts (ProductName, UnitPrice) in two
different tables. I'm not saying you have to store only ProductID, but it
is often the case that it is sufficient to store ONLY the ProductID.

The form, in design mode, has properties you can control. Take a look at
Access HELP on the Data Entry property. Check the newsgroups and/or Google
on "Add/Edit".

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I agree with you.

I did attempt to create a new form. Here is the problem that I am running
into.

I have all fields as follows:

LineItem
ProductName
Quantity
UnitPrice
ExtendedPrice
Notes

I then add a combo box: ProductCode with 3 columns to look up information
with ProductCode, ProductName, and UnitPrice.

How do I get the name and unit price to automatically be inserted into those
fields?

You said a form can be either look up data or data entry and that I can add
functionality to switch back/forth. I have never done this. Can you please
tell me how or where to look for information?

Thanks again.
JR

Were I in your situation, I'd probably be inclined to "start over".

I'd create a new form, based on the query (on the table). I'd add fields.
I'd confirm that the form is set up either to look up data or for data entry
(you can also add functionality to switch back/forth).

Sometimes, somehow, Access forms and reports can become subtly corrupted,
but still appear "normal", except for their functioning. I haven't been
able to spot how/when that happens, and realistically, I don't care. I tend
to operate on the basis of "if it doesn't work, don't spend a lot of time
trying to make it work. Find something (else) that will work..." Personal
philosophy, though, and may not match yours.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Sorry I did not explain in detail.

I can no longer enter info -- the control rejects data entry -- will not
accept ANY entry. It acts as if the field is locked; however, I have gone
back and verified that it is not. I also discovered that if I have no line
item number, the form will not allow any data entry in any other field
either. Using the form that has the combo box on the Product Name will
allow entry in all fields even if I do not have a line item number.

If I delete these fields, the form does the same thing. No data entry
allowed. Fields are available from the data elements.

If I reenter the fields from data elements, I get the same thing.

Hope this is clearer. I have only created one other form so please bear
with me.
JR

I don't understand. "I can no longer enter info" could mean that

you
can

type in the form control, but it doesn't "stick". Or that you can't type
anything - the control rejects data entry. Or you can type, but you get
an
error message (which says ????). Or ...??

What happens if you delete both controls from the form? Does it work
(except for what's missing in those two controls)?

What happens if, after deleting both, you open the form in design

mode
and

add a control from the list of available data elements? Are the two
fields
you want listed as available data elements?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


My apologies for creating a new post. I have not gotten a reply and
regardless of my changes, I cannot get this to work. Can someone please
comment? Many thanks in advance. JR


I just realized that I did not give you both of my SQL views:

This one works:

SELECT DISTINCTROW [Order Details].OrderDetailID, [Order
Details].OrderID,
[Order Details].LineItem, [Order Details].ProductID, [Order
Details].SerialNum, [Order Details].Quantity, [Order
Details].UnitPrice,
[Order Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total],
Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg, [Order Details].Notes
FROM Products INNER JOIN [Order Details] ON Products.ProductID =
[Order
Details].ProductID
ORDER BY [Order Details].LineItem;

The one below does not work.
The one difference I see is the change from Product ID to Product
Name.


I have a subform which has a field with a combo box. I want to
change
the combo box to another field on the form.

I have changed the original combo box to a text box and

created

a

combo
box for the desired field.

When I do this, I now can no longer enter info into the first field
of
my
form, but if I go past it, I get message that it does not have info
in
Dealer table. I did not change any field except the two boxes.
Below
is the SQL from my form:


SELECT DISTINCTROW [Order Details].OrderDetailID, [Order
Details].OrderID,
[Order Details].LineItem, Products.ProductName, [Order
Details].SerialNum,
[Order Details].Quantity, [Order Details].UnitPrice, [Order
Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total],
Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg
FROM Products INNER JOIN [Order Details] ON Products.ProductID =
[Order
Details].ProductID
ORDER BY [Order Details].LineItem;

Thank you,
Joy

 

[jwr]

I will try your suggestions. Thank you

Aha! I see one thing you can do that may simplify your task.

Since you are using a lookup (combo box) for Product-related information,
you may not need to store the ProductName and UnitPrice in the LineItem
table. Would it meet your needs to simply store the ProductID? That way,
you'd not be storing the same facts (ProductName, UnitPrice) in two
different tables. I'm not saying you have to store only ProductID, but it
is often the case that it is sufficient to store ONLY the ProductID.

The form, in design mode, has properties you can control. Take a look at
Access HELP on the Data Entry property. Check the newsgroups and/or Google
on "Add/Edit".

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I agree with you.

I did attempt to create a new form. Here is the problem that I am running
into.

I have all fields as follows:

LineItem
ProductName
Quantity
UnitPrice
ExtendedPrice
Notes

I then add a combo box: ProductCode with 3 columns to look up information
with ProductCode, ProductName, and UnitPrice.

How do I get the name and unit price to automatically be inserted into those
fields?

You said a form can be either look up data or data entry and that I can add
functionality to switch back/forth. I have never done this. Can you please
tell me how or where to look for information?

Thanks again.
JR

Were I in your situation, I'd probably be inclined to "start over".

I'd create a new form, based on the query (on the table). I'd add fields.
I'd confirm that the form is set up either to look up data or for data entry
(you can also add functionality to switch back/forth).

Sometimes, somehow, Access forms and reports can become subtly corrupted,
but still appear "normal", except for their functioning. I haven't been
able to spot how/when that happens, and realistically, I don't care.

I
tend

to operate on the basis of "if it doesn't work, don't spend a lot of time
trying to make it work. Find something (else) that will work..." Personal
philosophy, though, and may not match yours.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


Sorry I did not explain in detail.

I can no longer enter info -- the control rejects data entry -- will not
accept ANY entry. It acts as if the field is locked; however, I

have
gone

back and verified that it is not. I also discovered that if I have no
line
item number, the form will not allow any data entry in any other field
either. Using the form that has the combo box on the Product Name will
allow entry in all fields even if I do not have a line item number.

If I delete these fields, the form does the same thing. No data entry
allowed. Fields are available from the data elements.

If I reenter the fields from data elements, I get the same thing.

Hope this is clearer. I have only created one other form so please bear
with me.
JR

I don't understand. "I can no longer enter info" could mean that you
can
type in the form control, but it doesn't "stick". Or that you can't
type
anything - the control rejects data entry. Or you can type, but

you
get

an
error message (which says ????). Or ...??

What happens if you delete both controls from the form? Does it work
(except for what's missing in those two controls)?

What happens if, after deleting both, you open the form in design mode
and
add a control from the list of available data elements? Are the two
fields
you want listed as available data elements?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


My apologies for creating a new post. I have not gotten a reply and
regardless of my changes, I cannot get this to work. Can someone
please
comment? Many thanks in advance. JR


I just realized that I did not give you both of my SQL views:

This one works:

SELECT DISTINCTROW [Order Details].OrderDetailID, [Order
Details].OrderID,
[Order Details].LineItem, [Order Details].ProductID, [Order
Details].SerialNum, [Order Details].Quantity, [Order
Details].UnitPrice,
[Order Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total],
Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg, [Order Details].Notes
FROM Products INNER JOIN [Order Details] ON Products.ProductID =
[Order
Details].ProductID
ORDER BY [Order Details].LineItem;

The one below does not work.
The one difference I see is the change from Product ID to Product
Name.


I have a subform which has a field with a combo box. I want to
change
the combo box to another field on the form.

I have changed the original combo box to a text box and

created

a
combo
box for the desired field.

When I do this, I now can no longer enter info into the first
field
of
my
form, but if I go past it, I get message that it does not have
info
in
Dealer table. I did not change any field except the two boxes.
Below
is the SQL from my form:


SELECT DISTINCTROW [Order Details].OrderDetailID, [Order
Details].OrderID,
[Order Details].LineItem, Products.ProductName, [Order
Details].SerialNum,
[Order Details].Quantity, [Order Details].UnitPrice, [Order
Details].Discount, Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2) AS [Line Total],
Products.ProductCode,
[HandlingPct]*Round([Quantity]*[Order
Details].UnitPrice*(1-[Discount]),2)
AS HandlingChg
FROM Products INNER JOIN [Order Details] ON

Products.ProductID

=

[Order
Details].ProductID
ORDER BY [Order Details].LineItem;

Thank you,
Joy