External Excel Data - Forms not showing

[Verano.47]

Hi Guys,

Good day. I am having an issue and would like to solicit for your kind assistance.

I am using MS Access 2016. I created a table and able to manage to create forms.

Now, I decided that I want to use external excel data instead and linking them. I renamed to new excel table the same as the access table. But when I open the form, it is all blank. But when I switch to design view, the components are still there. I have already changed the control source but it is still the same.

I've made forms already and I hope I wont do creating the forms again, is there a way around with this?

Thank you in advance.

 

[NauticalGent]

Does the linked table/Spreadsheet have any records, specifically in the first row?

 

[isladogs]

In design view check whether the form controls are hidden

Also, normally forms are bound to tables.
If so, the text boxes should also be bound so just show a field name.
E.g. ProjectName

 

[Verano.47]

Hi Guys,

Yes, the excel file is the same as the original table.

I've tried two things in the Control Source.

1. I used the built-in link
2. Used expression

Still the form is blank.

I appreciate your reply. Thank you.

 

[NauticalGent]

A form that is bound to an empty table will be blank. Populate the records and see if that fixes it...

 

[Verano.47]

I tried populating the blank tables and there is no effect. I have noticed though that looking into relationship, the One to many or Enforce Integrity is greyed out and says "indeterminate" Unlike when you link an access table to another.

I cannot also assign a primary key into the linked excel file table.

 

[isladogs]

Its not possible to assign a key to a linked Excel table as you can't edit Excel tables from Access

So you need to use Excel tables as a 'buffer' & import the data to an Access table (with a PK field) THEN use that as the record source for your bound form