<div>
Instead of Requerying the Textbox, why don't you just add the data directly to it from the subform, like this:<br />
Forms![Main Form Name]![Field Name]= [Your Subform Field name]<br />
<br />
usually you want to requery a combobox so that it reflects new data.<br />
<br />
jaffer
</div>


Instead of Requerying the Textbox, why don't you just add the data directly to it from the subform, like this:
Forms![Main Form Name]![Field Name]= [Your Subform Field name]

usually you want to requery a combobox so that it reflects new data.

jaffer

<div>
You can also requery the Main Form and after you requery, you go back to the Record you were before (so the Form will not start from Record Number one),<br />
you can use RecordsetColon.Bookmark
</div>


You can also requery the Main Form and after you requery, you go back to the Record you were before (so the Form will not start from Record Number one),
you can use RecordsetColon.Bookmark

<div>
you second suggestion sounds best how do i go about that?<br />
<br />
Never used it.<br />
<br />
Ps there is a SQL trigger on the main txt boxes that why i am going down this route
</div>


you second suggestion sounds best how do i go about that?

Never used it.

Ps there is a SQL trigger on the main txt boxes that why i am going down this route

<div>
you are welcome,<br />
and thanks for the points and grade.<br />
<br />
jaffer
</div>


you are welcome,
and thanks for the points and grade.

jaffer

<div>
<div class="content wysiwyg-content">
i need to requery a txtbox on my main form when an entry is put into my sbform.<br />
<br />
I have tried Forms!frmTimeEntry.txtOTim<wbr />e.Requery on an after update event dosnt work.<br />
<br />
I cant requery the whole form due to a complex nature i will not get into.<br />
<br />
Thanks
</div>
</div>


i need to requery a txtbox on my main form when an entry is put into my sbform.

I have tried Forms!frmTimeEntry.txtOTime.Requery on an after update event dosnt work.

I cant requery the whole form due to a complex nature i will not get into.

Thanks

Suform requerring a main froms txtbox urgent 500 points

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.