edit fields in a record

[ppoindexter]

i have a bound form (to a query) that i want to use to edit records in a table

currently i have no problems finding specific records, i am just unsure how to handle the edits ...my vba skills are a quiet limited

the form has 10 combo boxes, 4 text boxes and 6 rich text boxes

i need to be able to change one or more fields of a specific record...keep in mind the rich text boxes data comes from another table...the data is not typed in but pulled in from a table

any ideas/help is appreciated

 

[WayneRyan]

p,

You said that it was a "bound" form. What exactly is the
problem?

Are you trying to bring up a specific record?

Wayne

 

[ppoindexter]

hi wayne
i can bring up a specific record to edit, however, i am not sure how i bring up the record (from another table) to replace a record in a "specific field" in the record

i think an example might be more clear:

tbl_Sequence
fld_sequence_id
fld_grade_id
fld_state_id
fld_gradingperiod_id
fld_week
fld_day
fld_year
fld_lesson1_id
fld_lesson2_id
fld_lesson3_id
fld_lesson1_rtf
fld_lesson2_rtf
fld_lesson3_rtf

lets say record 011 is pulled into the "editSequencefrm"
and fld_lesson1_id = record 455
and fld_lesson1_rtf = "Draw a polygon"
and i need to change
fld_lesson1_id to record 321
which populates fld_lesson1_rtf with "Draw a square"

hope that is clear enough...thanks

 

[WayneRyan]

p,

Still not quite clear here, but you could make the first field
a combobox bound to LessonID, with the RowSource:

Select LessonID, LessonText
From   OtherTable
Order by LessonID

Then you can use the AfterUpdate event to do:

Me.Lesson1_rtf = Me.Combo.Column(1)

Note, Anytime that you have fields like Lesson1, Lesson2,
Lesson3 that is a sign that they should belong in their own
table. You will end up with logic like:

If Lesson1 = "xx" Or Lesson2 = "xx" Or Lesson3 = "xx" Then ...
That gets cumbersome and there is always the chance that
you will encounter a case that needs 8 Lessons. In a seperate
table, that's no problem.

Wayne