Unable to display record in subform until mouse is scrolled

[MikeWaring]

Hi, I've created a subform within a main form but I can't get it to display the retreived data until I scroll the mouse wheel back to the previous record then forwards to the record I'm entering.

The set up is as follows:
The main form "GOODS RETURN" is for data entry of our Goods Returns process details (Reason for return, return date etc).

The subform is based on a Query that retrieves all the details of the original sale (Sales invoice number, customer name, product part number etc etc) from another table. The Subform is set to view in Single Form format.

The field that links both sets of data is the "Sales Invoice Number".

When a customer wishes to send an item back to us, I enter the original Sales Invoice Number into the first field of the "GGODS RETURN" main form. This then retrieves and displays all the details of the original sale, from that original Sales Record Number. We then complete the rest of the "GOODS RETURN" form and continue the process.

However, the subform doesn't display its details until I scroll the mouse wheel backwards and then forwards. What I need is that when I've entered the Sales Invoice Number into the field on the "GOODS RETURN" main form and then tab to the next data entry field on that form, it displays the related details.

I've tried using various actions in the "On Exit" property of the Sales Invoice Number field, including a macro to open then close the subform, requery the query that retrives the related details, repaint the subform, but none of these macro actions cause the subfrom to display immediately.


Any help would be gratefully received - there must be a way of doing this without having to scroll to another record and then back to the one I'm trying to enter? I suspect it needs a refresh action or something of that nature.



Thanks in advance

[June7]

Problem might be that Sales is not a child of GoodsReturned. Subform might not be best vehicle for displaying the invoice info. But really need better understanding of data structure. If you want to provide db for analysis, follow instructions at bottom of my post.

[Missinglinq]

As June7 suggests, the Sales Subform Record is not a Child of GoodsReturned Record; you've got the cart before the horse, as it were. You have to have a Main Form Record before creating a Subform Record.

You need to reverse what you're doing, with the Sales Records being in the Main Form and the Returns Records in the Subform.

In the Main Form, you can use a Wizard-generated Combobox to retrieve the appropriate Sales Record, then enter your Return Record data in the Subform.

Linq ;0)>

[MikeWaring]

Hi Both, thanks for the replies. I've managed to fix it after stumbling araound a bit - I set the On Exit Event Procedure to refresh the form and hey presto as soon as the curor leaves that field, the related records appear in the sub form.

Once again, thanks for your help.
Regards,
Mike