Re: subform connected to main form and another subform

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Scott (scottb_at_cecomet.net)
Date: 09/19/04 

Date: Sun, 19 Sep 2004 16:06:48 -0400

On Fri, 17 Sep 2004 10:27:27 -0400, Scott wrote:

> On Fri, 17 Sep 2004 00:13:20 -0500, Marshall Barton wrote:
>
>> Scott wrote:
>>
>>>Darren, et al, OK I found the way to enable the child/masater link
>>>properties, now I get an "Enter Parameter Value" box with "txtStayID" and a
>>>white space below to fill in. I do not know what I have done wrong.
>>
>> The Link Master property can be either a text box on the
>> main form or a field in the main form's record source
>> table/query.
>>
>> The link Child property **must** be a field in the subform's
>> record source table/query. It sounds as if you used a text
>> box here.
>
> SUCCESS!!!
> Thanks to all of you for the help.
>
> Best regards,
> Scott

Marshall, Darren , et.al., If you are still following this thread I have
yet more need for info. The original problem has been solved, but now
presents a new set of problems. First, the Item field (combo box) in the
item sales subform is jittery and does not act like a regular combo box. I
have to hold down the mouse button while I select the row I want or it just
flashes by and goes blank. Second, I cannot add a record of a sale of an
item with out a room stay record. I somtimes sell things without a room
stay and I would like to be able to keep track of both types of sales.
This is expecially important if I sell a gift certificate. Most GCs are
sold over the phone to someone who has not stayed wth us or is not
currently staying with us so the stay record would not be created.

I hope this is clear.

Best regards,
Scott

Relevant Pages

  • Re: join problem
    ... Regards ... Your query would start with the ... >> Absatz means sales in german and Mitarbeiter is Employee.ABSATZVORJAHR ...
    (microsoft.public.access.queries)
  • RE: How do I convert functions that are zero into a null ?
    ... In regards to my reply about the ISNAfunction, ... >> I have a sales worksheet that totals monthly from January thru December. ... >> I plot the summary sales by month in a simple line chart. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: News
    ... H FW managed to increase the sales of intensively reared birds during his ... outburst. ...
    (uk.business.agriculture)
  • Re: Would u help me with a Biggest Movers type of comparison?
    ... just realised you wanted the biggest changes as opposed to the ... Regards ... > Might want to consider a pivot table. ... > Drag your salesman ID field into the ROW areas and then drag the Sales ...
    (microsoft.public.excel.misc)
  • Re: Pivottable: Show value as a percent of Subtotal
    ... Perhaps that must come from the original poster? ... original problem description was, it's at the bottom of this post. ... Region and State are both Row area fields and Sales is the ...
    (microsoft.public.excel.misc)