Re: Trouble opening a form from a subform combo box

From: Tammy (Tammy_at_discussions.microsoft.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 08:11:02 -0800

Hi Steve,
Thanks for the idea, it just gives me a blank form and doesn’t bring up the
record I am looking for.
I am going to work on getting my Documents table straitened out and see if
that will help :-) I know its not set up right, it is almost a separate
database. It is only set up the way it is because I had to pull all then info
out of a dbase program before IT deleted it or messed it up.

Thanks for the help :-)
Tammy

"Steve Schapel" wrote:

> Tammy,
>
> If the problem really is the data type mismatch, this may fix it...
> [Part_Number]=Format([Forms]![ECO
> FORM]![subfrmAffectedParts]![tblPartNumber_ID])
>
> If tblPartNumber_ID is a number, and you are able to match it to the
> data in the [Part_Number] field, then [Part_Number] must also be
> comprised of digits, even though it is text type, right? So is there
> any reason why you can't just change the data type of [Part_Number] to
> Number?
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> Tammy wrote:
> > I was able to do this once before using a macro, but I have had to make alot
> > of changes to my database, and now it won't work.
> >
> > I have a macro to open my form Documents. I have the following code in the
> > where condtion.
> > [Part_Number]=Forms![ECO FORM]![subfrmAffectedParts]![tblPartNumber_ID]
> >
> > I think my problem is Part_Number in Documents is text, and the
> > tblpartnumber_id is a number. tblpartnumber_id is a combo box.
> >
> > Thanks
> >
>

Relevant Pages

  • Trouble opening a form from a subform combo box
    ... I was able to do this once before using a macro, but I have had to make alot ... of changes to my database, ... I have a macro to open my form Documents. ...
    (microsoft.public.access.forms)
  • Re: Date range on reports
    ... > box to your report with a control source like: ... >> In the Database window (Database window: The window that appears when you ... >> In the New Form dialog box, click Design View, and click OK. ... >> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Newbies first image: BSOD 0x7B
    ... Having all the components mentioned in the macro platform component would be ... > - add this component to the database using the Component Database Manager, ... > Info:Creating: LSI Logic FC909 Fibre Channel Adapter ...
    (microsoft.public.windowsxp.embedded)
  • Re: Combine Multiple tables into One Master table
    ... You can use a macro with 3 TransferText actions, one for each table, to get the data imported into your Access tables. ... the Open event of a form which always opens when the database opens - but then what if today's import has already been done. ... And then make an Update Query to add the data to the other fields from the related records in the other two import tables. ...
    (microsoft.public.access.macros)
  • Re: Copying the last record to a new record
    ... I have a macro that sets the time/date upon save, ... We could append this recordset (minus the primary key and substituting Now() ... as mytimestamp) to the database, sort the record source by mytimestamp ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.macros)