Combo Box

Well maybe I am confused. You're inserting records into a table called
tblQOE_New but the rowsource of your combobox doesn't look at this table. Are
the values in both tables or just the "new" table?

Barry

"sike11 via AccessMonster.com" wrote:

Hey Barry,

The InsertNew routine DOES insert a record into a table which is definitely
happening. I check the table after I run the form and it is holding the
information inserted via the form.
VwQOE_QOE_ManualEntry is the table on which qryQOE-ManualUpdate is based. I
do get values from this table but I then insert into a separate table
(tblQOE_New).
The rowsource of the combobox is based on qryQOE-ManualUpdate from which I
then choose the field(s) I want to display.
No, the SQL string in the rowsource is as follows:

" SELECT [qryQOE-ManualUpdate].student_studentreference, [qryQOE-
ManualUpdate].[student-surname],
[qryQOE-ManualUpdate].student_forenames, Trim([student_forenames]) & " " &
Trim([student-surname])
AS Student FROM [qryQOE-ManualUpdate] ORDER BY [qryQOE-ManualUpdate].
[student-surname];"

Have I totally confused you or does this make sense?

Please advise.

Regards,

Mary.

Barry Gilbert wrote:
A few questions:
What does the InsertNew routine do? Does it insert a new record or update an
existing record? Are you sure this insert/update is happening?
What is Vw_QOE_ManualEntry? Does this get values from the same table you're
inserting into?
Is the SQL string the rowsource of the combobox?

Barry

Hi Barry,

[quoted text clipped - 15 lines]

Mary.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200605/1

Hi Barry,

The values are in both tables. The Vw_QOE_ManualEntry table is linked to a
SQL server. We just link to gain information about students. The rowsource of
the combo box is based on the query which uses the Vw_QOE_ManualEntry,
therefore, it does look at the table.
Please help.

Mary.

Barry Gilbert wrote:
Well maybe I am confused. You're inserting records into a table called
tblQOE_New but the rowsource of your combobox doesn't look at this table. Are
the values in both tables or just the "new" table?

Barry

Hey Barry,

[quoted text clipped - 37 lines]

Mary.

--
Message posted via http://www.accessmonster.com

I guess I'd want to know if the problem is with the data or with the form.
Can you paste the rowsource into a query, run the update, and immediately run
the query to see if it returns an updated list? If it does, then the problem
is with the requery of the combobox.

Barry

"sike11 via AccessMonster.com" wrote:

Hi Barry,

The values are in both tables. The Vw_QOE_ManualEntry table is linked to a
SQL server. We just link to gain information about students. The rowsource of
the combo box is based on the query which uses the Vw_QOE_ManualEntry,
therefore, it does look at the table.
Please help.

Mary.

Barry Gilbert wrote:
Well maybe I am confused. You're inserting records into a table called
tblQOE_New but the rowsource of your combobox doesn't look at this table. Are
the values in both tables or just the "new" table?

Barry

Hey Barry,

[quoted text clipped - 37 lines]

Mary.

--
Message posted via http://www.accessmonster.com

Hi Barry,

Sorry to have taken so long to reply.

I tried what you suggested. Everything works fine apart from the requerry of
the combobox. The query returns the required list. I am unsure how to proceed
from here.
Any ideas?


Barry Gilbert wrote:
I guess I'd want to know if the problem is with the data or with the form.
Can you paste the rowsource into a query, run the update, and immediately run
the query to see if it returns an updated list? If it does, then the problem
is with the requery of the combobox.

Barry

Hi Barry,

[quoted text clipped - 17 lines]

Mary.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200605/1

If the table is being correctly updated, the requery method should work.
There must be something else going on. Without seeing it in person, I'm out
of ideas.

Barry

"sike11 via AccessMonster.com" wrote:

Hi Barry,

Sorry to have taken so long to reply.

I tried what you suggested. Everything works fine apart from the requerry of
the combobox. The query returns the required list. I am unsure how to proceed
from here.
Any ideas?


Barry Gilbert wrote:
I guess I'd want to know if the problem is with the data or with the form.
Can you paste the rowsource into a query, run the update, and immediately run
the query to see if it returns an updated list? If it does, then the problem
is with the requery of the combobox.

Barry

Hi Barry,

[quoted text clipped - 17 lines]

Mary.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200605/1

Hello Barry,

Success at last!!!! I managed to get it working by requerying the combo box
in the AfterUpdate event of 1 of the textboxes.

Thank you very much for all the help you gave me, very much appreciated!!

Regards,

Mary.

Barry Gilbert wrote:
If the table is being correctly updated, the requery method should work.
There must be something else going on. Without seeing it in person, I'm out
of ideas.

Barry

Hi Barry,

[quoted text clipped - 17 lines]

Mary.

--
Message posted via http://www.accessmonster.com