Recent content by DanWall

Good morning. (I forgot to mention in thread title: This is Access 2007.) Please bear with me as I explain the problem. I have a table as the recorsource of a parent form. (tblBHA) A subform is embedded in the parent form, as a continuous form. (subfrmSlide) The data for the subform is a...

Hmmmm, I know the wizards always do stuff like this, but have you tried: Expression: "[Title]=" & [Movie Title] Or better yet, use the unique ID (key) as the filter "[ID] = " & [ID]

Or oblong.... What then?

Thanks Backosoft, BUT, the line you have written there won't work. It will only select the ITEMS, with the ID field the same as the BACKLOAD table's ID. I have it figured out now.... the correct SQL should be: UPDATE tblItems SET tblItems.Backload = Forms![frmBackloadEdit]![ID] WHERE...

Tip of the day: If you measure from the "underside", you get an extra inch.

Re: A message from TimsfriendMartin'sfriendBarry

Re: A message from TimsfriendMartin'sfriendBarry

[Resolved] - RunSQL Macro - Can't figure it out! Hi All... I have a subform, embedded into another form. Main Form = frmBackloadEdit (The "backload" details - linked to tblBackloads) Subform 1 = subfrmBackloadItems (A filtered list of items from the tblItems table, that have the...

Thanks very much for your attempts guys. I really appreciate the effort. Boyd, you are correct, I need to pass information to a new field. I'm still playing around with it, but I think I've nearly found a solution. I'll post it for you to see once I've done it... Thanks again. Dan.

Good afternoon. I have a form, which is bound to a table. (frmDeliveries / tblDeliveries) There is another table called tblItems with a [Delivery] field, which is linked to the tblDeliveries.[ID] field. The problem I'm having is this.... As I'm entering a new field in the Deliveries form...

It's in the excel options of the software, and each machine will have different settings. You can change it the excel security settings.

Here you go. It's not as complex as what you're trying to do, but it shows an example of how you would use a lookup to determine the correct row to use. It should get you started at least.

No worries, Glad I could help.